查询第m至第n条记录的方法
1. 常用的top指定查询结果中将只返回第一组行。这组行可以是某一数量的行也可以是某一百分比数量的行
select top (n-m+1) * from t1
where pkid not in
(select top (m-1) pkid from users order by pkid )
order by pkid
2. ROW_NUMBER()返回结果集分区内行的序列号,每个分区的第一行从 1 开始,不过开窗函数不支持整数索引作为 ORDER BY 子句表达式
select *
from
(select *, ROW_NUMBER() over (order by pkid ) as row_number from t1
as temp
where temp.row_number>=m and temp.row_number<=n