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
转载于:https://www.cnblogs.com/fanying/p/10919109.html
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
转载于:https://www.cnblogs.com/fanying/p/10919109.html