分页 语句
SELECT w2.n,
w1.*
FROM XsTable w1,
(SELECT TOP 1030 row_number()
OVER (ORDER BY xsxxtim DESC) n, XsID
FROM XsXXTable ) w2
WHERE w1.XsID = w2.XsID
AND w2.n > 1000
ORDER BY w2.n ASC
SQL server 高效分页
于 2022-04-25 22:40:59 首次发布
分页 语句
SELECT w2.n,
w1.*
FROM XsTable w1,
(SELECT TOP 1030 row_number()
OVER (ORDER BY xsxxtim DESC) n, XsID
FROM XsXXTable ) w2
WHERE w1.XsID = w2.XsID
AND w2.n > 1000
ORDER BY w2.n ASC