--查询第20-30条select top 10 * from Orders where OrderID> (select max(OrderID) from (select top 20 OrderID from Orders order by OrderID ASC ) t0)