查1000行到2000行之间的纪录怎么查？？？

[asxulong]

查1000行到2000行之间的纪录怎么查？？？

[asxulong]

有没有人会啊！帮帮忙了

[NinGoo]

alter table table1 add column NewID int identity(1,1)

select col1,col2..from table1 where NewID>=1000 and NewID<=2000

alter table table1 drop column NewID

[asxulong]

没有一句就能查出来的哦!
就像select top 100 * from table;

[NinGoo]

上面有点小小的语法错误，增加列时用add不是add column，呵呵

alter table table1 add NewID int identity(1,1)

select col1,col2..from table1 where NewID>=1000 and NewID<=2000

alter table table1 drop column NewID

[zhuxiaojun2002]

select top 1000 id from table
where id not in (select top 1000 id from table order by id)
order by id

http://community.csdn.net/Expert/topic/3513/3513760.xml?temp=.9601862

[NinGoo]

select top 1000 id from table
where id not in (select top 1000 id from table order by id)
order by id


这个需要ID唯一才能得到正确的结果

[MY128]

关注中,帮你顶一下

[wuzhouhome]

你没有给出标识怎么查？？

[likesunny]

先查rs1:top 1000 然后再查rs2:top 2000并且不在 not in rs1中就可以了!