Last N records from a Table in SQL

Question

How to select last N records from a Table ?

Vithal Wadje · Answer

select Max (id) from tablename

Krishna Garad · Answer

If you have Id column in database then try order by like Select Top 10 * From TableName order by Id Desc Else Take a look here

Shankar M · Answer

Hi Sharad Use the Order by Clause in your Query. Something like this SELECT TOP N * FROM EMP ORDER BY EMPNO DESC Thanks Shankar