select top 10 * from table where field not in(select top 10*(n-1) key from table) for example: use pubs go select top 10 au_id from authors where au_id not in (select top 20 au_id from authors )
select * from (select * from tablename) where id > 10 and id < 21;try it!
select top 10 * from (select top 20 * from youtable order by filed1 desc ) x order by filed1 asc
或者 select identity(int,1,1) x , * into #tmp from yourtable where ...select * from #tmp where x >=10 and x<20
where field not in(select top 10*(n-1) key from table)
for example:
use pubs
go
select top 10 au_id from authors where au_id not in (select top 20 au_id from authors )
(select * from tablename)
where id > 10 and id < 21;try it!
select identity(int,1,1) x , * into #tmp from yourtable where ...select * from #tmp where x >=10 and x<20