SELECT TOP 页大小 *
FROM table1
WHERE ID>
(
SELECT ISNULL(MAX(ID),0)
FROM
(
SELECT TOP (页大小*(页数-1))ID FROM table1 ORDER BY ID
) A
)
ORDER BY ID
SELECT TOP 页大小 *
FROM table1
WHERE id NOT IN
(
SELECT TOP (页大小*(页数-1)) id FROM table1 ORDER BY id
)
ORDER BY id
SELECT *
FROM
(
SELECT TOP 页大小 *
FROM
(SELECT TOP (页大小*页数) id FROM table1 ORDER BY id) t1
ORDER BY id DESC
) t2
ORDER BY id