用SQL查询能查到从第200条到第500条的数据吗?

用SQL查询能查到从第200条到第500条的数据吗?
我指的是只用SQL查询语言查询

先谢谢jiehuangwei,假如用asp怎么做?

可以，假设你的表主键是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

可以先rank一下，在写条件 再看看别人怎么说的。

单纯的SQL不行，得嵌套在别的语言中才行。

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