适用于sql server2000/2005
select top 页大小*
from table
where id not in(
select top 页大小*(页数-1) id from table order by id
)
order by id
适用于sql server2000/2005
select top 页大小*
from table
where id not in(
select top 页大小*(页数-1) id from table order by id
)
order by id
![oracle中的start with connect by用法[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)