Sql query

Question

User-1458744719 posted

Sql query to get latest row added in the table

Answer 1

User1648350404 posted

if ID is primary key and identity column

SELECT *
FROM    TABLE
WHERE   ID = (SELECT MAX(ID)  FROM TABLE)

OR

select top 1 * from TABLE_NAME  order by ID desc

OR

SELECT *
FROM    TABLE
WHERE  ID = IDENT_CURRENT('TABLE')

Answer 2

User681036950 posted

There's a lot you're not telling us.  Do you have a primary key?  Is that key a sequential int?

If so you can use this to get the last one entered:

SELECT TOP 1 * FROM TABLE order by Primary_Key_ID desc

Answer 3

User-1598965247 posted

if you have set primary key as an identity column then use

select @@IDENTITY

to get the last inserted identity value

Answer 4

User-1590429200 posted

Look at this example:

1. CREATE TABLE [dbo].[EmpTbl]([Eid] [int] IDENTITY(1,1) NOT NULL,[Ename] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL) ON [PRIMARY]
   
   
2. Insert into Emptbl values('sen')

3. select * from emptbl where Eid=@@identity

    

Answer 5

User-665004399 posted

hi,

if you have any data r datetime column in your table you can give order by that column desending

for ex:

SELECT top 1 *
    FROM  your_table_name
    ORDER BY your_date_time_column DESC

Answer 6

User71929859 posted

Hello,

Resolved thread here - http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/8092652e-843e-4064-8a53-4af7237f19ae?prof=required&ppud=4

Answer 7

User-116196265 posted

select  scope_identity()