select top 10 * from Orders where OrderID not in (select top 20 OrderID from Orders order by OrderID ) 我这是取20到30之间的10条数据!