查询从m到n的这几条记录
m-n
go
select 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 )
查询从m到n的这几条记录
m-n
go
select 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