declare @pageindex int declare @pageSize intset @pageindex = 0 set @pagesize = 20; with temp as( select 字段1, row_number() over(order by 某字段) as row from 某表 ) select * from temp where row between @pageindex * @pagesize and ( @pageindex + 1 ) * @pagesize
declare @pageindex int
declare @pageSize intset @pageindex = 0
set @pagesize = 20;
with temp as(
select
字段1,
row_number() over(order by 某字段) as row
from 某表
)
select * from temp
where row between @pageindex * @pagesize and ( @pageindex + 1 ) * @pagesize