查询从m到n的这几条记录
m-n
goselect top (n-m+1) * from stu where id not in (select top (m-1) ID from stu )--51-100
select top 50 * from stu where id not in (select top 50 ID from stu )本文共 242 字，大约阅读时间需要 1 分钟。
查询从m到n的这几条记录
m-n
goselect top (n-m+1) * from stu where id not in (select top (m-1) ID from stu )--51-100
select top 50 * from stu where id not in (select top 50 ID from stu )转载于:https://www.cnblogs.com/kuang/archive/2012/07/19/2599344.html