select top @pagesize * from table1 where id not in (select top @pagesize*(@page-1) id from table1 order by id) order by id