The various gameplay of SQL Server 31st to 40th Records

--two times less efficient for table a queries
Select Top 10 *
From A
where ID not in (select top with ID from A)

--The outer query does not query the table A, the efficiency is greatly improved
Select Top 10 *
From (select top-from-A order by ID) as T

ORDER BY t.id Desc

--row_number () function is more efficient and can be used in sqlserver2005 and above versions
SELECT *

From (select Row_number () up (order by ID) as ' sequence ', a.* from A) as T

where t.sequence between and 40

SELECT * from A Order by ID OFFSET-rows FETCH NEXT ten rows only

The various gameplay of SQL Server 31st to 40th Records