This is a known question but the best solution I've found is something like:
SELECT TOP N *
ORDER BY Id DESC
I have a table with lots of rows. It is not a possibility to use that query because it takes a lot of time. So how can I do to select last N rows without using ORDER BY?
Sorry duplicated question of this one