分页存储过程

最新推荐文章于 2024-09-05 18:50:50 发布

最新推荐文章于 2024-09-05 18:50:50 发布 · 84 阅读

文章标签：

#sql server 分页

数据库专栏收录该内容

10 篇文章

订阅专栏

---------------------- 方法1-------------------
利用Not In和SELECT TOP分页)
SELECT TOP 10 *
FROM users
WHERE (indexId NOT IN
(SELECT TOP 30 indexId
FROM users
ORDER BY indexId))
ORDER BY indexId

SELECT TOP 页大小 *
FROM TestTable
WHERE (ID NOT IN
(SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id))
ORDER BY ID
---------------------- 方法2------------------
二：(利用ID大于多少和SELECT TOP分页
SELECT TOP 10 *
FROM users
WHERE (indexID >
(SELECT MAX(indexID)
FROM (SELECT TOP 20 indexID
FROM users
ORDER BY indexID) AS T))
ORDER BY indexID

SELECT TOP 页大小 *
FROM TestTable
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id) AS T))
ORDER BY ID