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
2022-03-20 20:23:00
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