Safest way to get last record ID from a table

Question

In SQL Server 2008 and higher what is the best safest most correct way    to retrieve the ID  based on autoincrementing primary key  out of the database table  to retrieve the value of the last row of some other column  like  SELECT TOP 1 FROM Table ORDER BY DESC

User · Answer

I think this one will also work      SELECT   FROM  ORDER BY id DESC LIMIT 0   1

User · Answer

SELECT IDENT CURRENT  Table     You can use one of these examples   SELECT   FROM Table  WHERE ID         SELECT IDENT CURRENT  Table     SELECT   FROM Table WHERE ID         SELECT MAX ID  FROM Table   SELECT TOP 1   FROM Table ORDER BY ID DESC   But the first one will be more efficient because no index scan is needed  if you have index on Id column    The second one solution is equivalent to the third  both of them need to scan table to get max id

User · Answer

SELECT LAST row name  FROM table name

User · Answer

You can try   SELECT id FROM your table WHERE id    SELECT MAX id  FROM your table    Where id is a primary key of the your table

User · Answer

Safest way will be to output or return the scope identity   within the procedure inserting the row  and then retrieve the row based on that ID  Use of   Identity is to be avoided since you can get the incorrect ID when triggers are in play   Any technique of asking for the maximum value   top 1 suffers a race condition where 2 people adding at the same time  would then get the same ID back when they looked for the highest ID

User · Answer

One more way -  select   from  lt table gt  where  id  select max id  from  lt table gt     Also you can check on this link -  http   msdn microsoft com en-us library ms175098 aspx

User · Answer

And if you mean select the ID of the last record inserted  its  SELECT   IDENTITY FROM table

User · Answer

1   SELECT MAX Id  FROM Table

[sql] Safest way to get last record ID from a table

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008