Find last Record in sql table

Question

How to Find Last Record in SQLtable without using Top and max

Vulpes · Answer

It depends which relational database you're using. In SQL Server you do what Vikram described. If you're using MS Access MySQL or Oracle you can use the approaches described here: http://www.w3schools.com/sql/sql_func_last.asp

Mukesh Kumar Tiwari · Answer

SELECT TOP 1 * FROM ItemMaster ORDER BY ItemId DESC;

Vikram Agrawal · Answer

Hi Apurv you can find last row like this without using top/max set rowcount 1 Select * From MyTable Order By Id Desc