-
高效率分页查询
SELECT * FROM table w1, ( SELECT TOP 30 id FROM ( SELECT TOP 1001030 id FROM table ORDER BY id ) w ORDER BY w.id ) w2 WHERE w1.id = w2.id ORDER BY w1.id
SQLServer杂记
最新推荐文章于 2023-06-16 15:15:30 发布
高效率分页查询
SELECT
*
FROM
table w1,
(
SELECT TOP
30 id
FROM
( SELECT TOP 1001030 id FROM table ORDER BY id ) w
ORDER BY
w.id
) w2
WHERE
w1.id = w2.id
ORDER BY
w1.id