How to select latest records from table without sorting?

Question

SQL

You need to select the last 10 records from the table without using sorting. MS SQL Server 2012

Answer 1

Good afternoon,
Query:
SELECT ID FROM `components` WHERE
ID BETWEEN (SELECT MAX(ID) FROM components)-10 AND (SELECT MAX(ID) FROM components)
At least MySQL does not use sorting, maybe. and in MSSQL will give a ride. ID - index, auto-increment. But when deleting records, you will have to renumber records that are larger than the one being deleted, but there is one simple request (set id=id-1)
Good luck!

Answer 2

In general, the answer to your question is that it is not possible, even if you use a clustered index there is still no guarantee that it will be used.

Answer 3

there is a table with columns: id, components, Created_date . You need to select the last ten entries added to it, that is, the last 10 components

Answer 4

You can definitely do it, but here's how...