sql server的表中数据量大时,分页查询需要查询指定范围内的记录,比如行号为100--200之间的记录,可以使用使用row_number()函数进行编号
select * from (
select row_number()over(order by id ) as rn,* from dbo.DangerRecord)dr
where rn>100 and rn<120
或
; with dr as(
select row_number()over(order by id ) as rn,* from dbo.DangerRecord
)
select * from dr where rn<120 and rn>100