SELECT * FROM (SELECT SalesOrderID, OrderDate,ROW_NUMBER() OVER (order by OrderDate)as RowNumber FROM Sales.SalesOrderHeader ) WHERE RowNumber between 50 and 60比如这里,如何得知sales表的记录总数,或者说RowNumber的最大值?
SELECT * FROM (SELECT SalesOrderID, OrderDate,ROW_NUMBER() OVER (order by OrderDate)as RowNumber FROM Sales.SalesOrderHeader union all select '','',(select count(1) from Sales.SalesOrderHeader) ) WHERE RowNumber between 50 and 60
--RowNumber 最大值 select max(RowNumber) from ( SELECT SalesOrderID, OrderDate,ROW_NUMBER() OVER (order by OrderDate)as RowNumber FROM Sales.SalesOrderHeader )tb
*
FROM
(SELECT SalesOrderID, OrderDate,ROW_NUMBER() OVER (order by OrderDate)as RowNumber FROM Sales.SalesOrderHeader
union all
select '','',(select count(1) from Sales.SalesOrderHeader) )
WHERE RowNumber between 50 and 60
select max(RowNumber)
from
(
SELECT SalesOrderID, OrderDate,ROW_NUMBER() OVER (order by OrderDate)as RowNumber
FROM Sales.SalesOrderHeader
)tb