select aa=identity(int,1,1),* into # from tt select top 10 * from # where aa>=30
select top 10 * from tab where id not in (select top 30 id from tab order by id ) order by id select top 10 * from tab where id in (select top 40 id from tab order by id) order by id desc
