How to get a row was inserted most recently in a table?

Posted by Syedshakeer on 9/8/2009 | Category: Sql Server Interview questions | Views: 9473

Answer:

select top 1 * from tablename order by ColumnName desc

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to Get nth Record in a Table?

Next > : Which of the following Regular expression is used ...

Posted by: Pandians on: 9/8/2009

Hi

Pl specify the ColumnName you used (Is it InsetedDate/Identity Value / Something else ?).
So that It will be useful to others .

Cheers

Posted by: Kapil.j.dhokai on: 9/21/2009

get a row was inserted most recently in a table

select top * 1 from table_name order by 1 desc

More Interview Questions by Syedshakeer

Latest Interview Questions