sqlserver查询某条到某条，1000条后的语句

 

一千条之前需要下面的语句

select top 1000 id from project order by id

一千条之后需要下面的语句

select top 1000 id from project
where isdelete=0 and id not in(select top 10000id from project where isdelete=0 order by id)order by id