Give the query of getting last two records from the table in SQL SERVER?
Akhil Joshi
If auto increment (identity) is applyed on one of the column of the table thanSELECT top(2) * FROM Testtable order by id descelseusing physical address we can find last two records of table.like SELECT top(2) * FROM Testtable order by %%physloc%% desc