查询第m条到第n条记录

没啥说的,一看就明白.

SELECT TOP 10 * FROM
  (SELECT TOP 30 * FROM Customers ORDER BY Id ASC) AS Table1
ORDER BY Id DESC 

 

另一种方法是

select top 17 * from a where id not in (select top 4 * from a order by id) order by id