有id:
select * from table1 where id>=100 and id<=200
无id临时表:
select id=identity(int,1,1),* into temp from table1
select * from temp where id>=100 and id<=200
drop table temp
select * from table1 where id>=100 and id<=200
无id临时表:
select id=identity(int,1,1),* into temp from table1
select * from temp where id>=100 and id<=200
drop table temp
select * from #tb where id between (x-1)*y and x*y-1
where id not in (select top 100 id from table1 where id in (select top 200 id from table1))
where id not in (select top 100 id from table1 where id in (select top 200 id from table1))