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