详细阐述Somnath-Muluk的回答:

SELECT *
FROM table_name_here
ORDER BY (SELECT NULL AS NOORDER)
OFFSET 9 ROWS 
FETCH NEXT 25 ROWS ONLY 

W /o添加任何额外的列。 在SQL Server 2019中测试，但我猜也可以在旧的版本中工作。

您可以在公共表表达式中使用ROW_NUMBER来实现这一点。

;WITH My_CTE AS
(
     SELECT
          col1,
          col2,
          ROW_NUMBER() OVER(ORDER BY col1) AS row_number
     FROM
          My_Table
     WHERE
          <<<whatever>>>
)
SELECT
     col1,
     col2
FROM
     My_CTE
WHERE
     row_number BETWEEN @start_row AND @end_row

在SQL server中，你可以使用TOP和ROW_NUMBER()

特别是对于SQL-SERVER，您可以通过许多不同的方式实现这一点。对于给定的真实例子，我们取Customer表。

例1:使用"SET ROWCOUNT"

SET ROWCOUNT 10
SELECT CustomerID, CompanyName from Customers
ORDER BY CompanyName

若要返回所有行，请将ROWCOUNT设置为0

SET ROWCOUNT 0  
SELECT CustomerID, CompanyName from Customers
    ORDER BY CompanyName

例2:使用"ROW_NUMBER and OVER"

With Cust AS
( SELECT CustomerID, CompanyName,
ROW_NUMBER() OVER (order by CompanyName) as RowNumber 
FROM Customers )
select *
from Cust
Where RowNumber Between 0 and 10

例3:使用“OFFSET and FETCH”，但是使用这个“ORDER BY”是强制的

SELECT CustomerID, CompanyName FROM Customers
ORDER BY CompanyName
OFFSET 0 ROWS
FETCH NEXT 10 ROWS ONLY

希望这对你有所帮助。

-- @RowsPerPage  can be a fixed number and @PageNumber number can be passed 
DECLARE @RowsPerPage INT = 10, @PageNumber INT = 2

SELECT *

FROM MemberEmployeeData

ORDER BY EmployeeNumber

OFFSET @PageNumber*@RowsPerPage ROWS

FETCH NEXT 10 ROWS ONLY

这个特性现在在SQL Server 2012中变得很容易。 这是从SQL Server 2012开始工作的。

在SQL Server中限制偏移量为11到20行:

SELECT email FROM emailTable 
WHERE user_id=3
ORDER BY Id
OFFSET 10 ROWS
FETCH NEXT 10 ROWS ONLY;

订购方式:必需 OFFSET:可选的跳过行数 NEXT:所需的下一行数

参考:https://learn.microsoft.com/en-us/sql/t-sql/queries/select-order-by-clause-transact-sql