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