SELECT TOP 500 * FROM yourTable ORDER BY yourOrderCol
select top 500 * from tablename order by 字段1....
select top 400 * from tablename where ( field1 not in (select top 100 field1 from tablename)) AND ( field2 not in (select top 100 field2 from tablename)) ... AND ( fieldn not in (select top 100 fieldn from tablename))
select identity(int,1,1) as id , * into #a from table order by col_1 select * from #a where id between 100 to 500 drop table #a
FROM yourTable
ORDER BY yourOrderCol
order by 字段1....
where ( field1 not in (select top 100 field1 from tablename))
AND ( field2 not in (select top 100 field2 from tablename))
...
AND ( fieldn not in (select top 100 fieldn from tablename))
select * from #a where id between 100 to 500
drop table #a