SELECT TOP 页大小 *
FROM TestTable WHERE (ID > (SELECT case when count(0) < 页大小 then 0 else MAX(id) FROM (SELECT TOP 页大小*(页数-1) id FROM 表 ORDER BY id) AS T)) ORDER BY ID本文共 166 字，大约阅读时间需要 1 分钟。
SELECT TOP 页大小 *
FROM TestTable WHERE (ID > (SELECT case when count(0) < 页大小 then 0 else MAX(id) FROM (SELECT TOP 页大小*(页数-1) id FROM 表 ORDER BY id) AS T)) ORDER BY ID转载地址：http://efsdo.baihongyu.com/