没啥说的,一看就明白.
SELECT TOP 10 * FROM (SELECT TOP 30 * FROM Customers ORDER BY Id ASC) AS Table1ORDER BY Id DESC
另一种方法是
select top 17 * from a where id not in (select top 4 * from a order by id) order by id
