如何在SQL Server中实现LIMIT？

启动SQL SERVER 2005，您可以执行此操作…

USE AdventureWorks;GOWITH OrderedOrders AS(    SELECt SalesOrderID, OrderDate,    ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'    FROM Sales.SalesOrderHeader ) SELECt * FROM OrderedOrders WHERe RowNumber BETWEEN 10 AND 20;

或类似的东西，适用于2000及以下版本…

SELECt TOP 10 * FROM (SELECt TOP 20 FROM Table ORDER BY Id) ORDER BY Id DESC