--假设主建为id
select top 200 * from table1
where id not in(select top 99 id from table1 order by id)
order by id
--假设没有主建
select id =identity(int,1,1),* into # from table1
select * from # where id between 100 and 200
drop table #
select top 200 * from table1
where id not in(select top 99 id from table1 order by id)
order by id
--假设没有主建
select id =identity(int,1,1),* into # from table1
select * from # where id between 100 and 200
drop table #
select * from # where id between 100 and 200
drop table #
这个方法比较好
select * from # where id between 100 and 200
drop table #
同意这个例子
where id between 100 and 200