SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (ORDER BY ID DESC ) AS r_num
FROM (select * from #table ) AS t1
) AS t2
WHERE r_num BETWEEN (1-1)*10+1 AND 1*10
SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (ORDER BY ID DESC ) AS r_num
FROM (select * from #table ) AS t1
) AS t2
WHERE r_num BETWEEN (1-1)*10+1 AND 1*10