可以，假设你的表主键是Id,表名是T
select *
from T
where id not in(
select top 200 Id
from T
order by Id)
and Id in(
select top 500 Id
from T
order by Id)
order by Id
select *
from T
where id not in(
select top 200 Id
from T
order by Id)
and Id in(
select top 500 Id
from T
order by Id)
order by Id
温馨提示：内容为网友见解，仅供参考
第1个回答 2008-03-23
单纯的SQL不行，得嵌套在别的语言中才行。
第2个回答 2008-03-24
select top 300 *
from
(select top 500 *
from Table1
order by field1 )as zzz
order by field1
或者：select top 300 from Table where field1>all(select top 500 from Table boder by field1) order by field
或者:select top 300 from table where field1 not in (select top 500 from table order by filed) order by field
from
(select top 500 *
from Table1
order by field1 )as zzz
order by field1
或者：select top 300 from Table where field1>all(select top 500 from Table boder by field1) order by field
或者:select top 300 from table where field1 not in (select top 500 from table order by filed) order by field
第3个回答 2008-03-23
可以先rank一下，在写条件
相似回答
