--从people1中取出第n到第m条的数据
select top m-n+1 *
from people1
where (ID not in(select top n-1 id from people1))
--不在前4条的id(id是5+)中的前四条
例如:--从people1中取出第五到第八条的数据
select top 4 *
from people1
where (ID not in(select top 4 id from people1))
--从people1中取出第n到第m条的数据
select top m-n+1 *
from people1
where (ID not in(select top n-1 id from people1))
--不在前4条的id(id是5+)中的前四条
例如:--从people1中取出第五到第八条的数据
select top 4 *
from people1
where (ID not in(select top 4 id from people1))