查找200-500之间的数据sql语句

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;

转载于:https://blog.51cto.com/13010541/1934721