sql2种分页

2024-01-06 23:34:16

declare @time datetime
declare @ms int
set @time= getdate()
select ID,name from (select row_number() over(order by ID) as rowNum,* from dbo.testb) as t where rowNum between 500000 and 500100
set @ms=datediff(ms,@time,getdate())
print @ms

select top 100 * from dbo.testb where Id not in
    (select top 500000 id from dbo.testb order by id)
    order by id