适用于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=)