sql server

升序
SELECT TOP 页大小 *
FROM TestTable
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id) AS T))
ORDER BY ID
 
降序
SELECT TOP 页大小 *
FROM TestTable
WHERE (ID <
(SELECT MIN(id)
FROM (SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id desc) AS T))
ORDER BY ID desc