22,209
社区成员
发帖
与我相关
我的任务
分享
Declare @pageIndex int = 800;
Declare @pageSize int = 20;
-- 分页查询1
Select * From [order] Order By id asc Offset (@pageIndex-1)*@pageSize Rows Fetch Next @pageSize Rows Only
-- 分页查询2
SELECT * FROM [order] WHERE ID IN (
SELECT ID FROM (SELECT ID,ROW_NUMBER() OVER ( ORDER BY ID asc) AS num FROM [order]) AS settable
WHERE num BETWEEN (@pageIndex-1)*@pageSize + 1 AND @pageIndex*@pageSize )
-- 分页查询3
SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY id) AS rid,* FROM [order]) AS t
WHERE t.rid between (@pageIndex-1) * @pageSize+1 AND @pageIndex*@pageSize