[存档]MSSQL分页

MSSQL:

select top 30 * from Ctrip2TaobaoHotelRoomType  where id not in (select top 120 id from Ctrip2TaobaoHotelRoomType order by id) order by id;

PHP:

$pagesql = "select top ".$showrow." * from Ctrip2TaobaoHotelRoomType where id not in (select top ".($curpage - 1) * $showrow." id from Ctrip2TaobaoHotelRoomType order by id) order by id;";