sql查询从m到n的这几条记录

查询从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 )