谢谢大家,实验通过,语句如下:
select top 10 *
from T
where id not in (select top 30 id from T order by id asc)
order by id asc
结帖
这是在ID唯一的情况下才可用的!如果ID不唯一,将是错误的!
友情提醒!
set rowcount 40
select [tmp]=identity(int,1,1),* into #t from T where (查询条件) order by ID
set rowcount 0
select [id],XXX from #t where [tmp] between 31 and 40