sql 分页

SELECT TOP 10
*
FROM(
SELECT ROW_NUMBER() OVER (ORDER BY ID ASC) AS rownumber, *
FROM
(
SELECT * FROM Person

)t) temp_row
WHERE rownumber > ((2 - 1) * 10);

sql serve2012以后可以使用

SELECT * FROM Person

ORDER BY Name desc
OFFSET (3-1)*10 ROWS
FETCH NEXT 10 ROWS ONLY