Hi all,
In the BOL for SQL Server 2005 Beta 2 (Yukon) the given example is
USE AdventureWorks
GO
WITH OrderedOrders AS
(SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (order by OrderDate)as RowNumber
FROM Sales.SalesOrderHeader )
SELECT *
FROM OrderedOrders
WHERE RowNumber between 50 and 60
But when I first meet this question, I solved in the following method
select * from (
select row_number() over(order by cityname) rid, * from Cities
) x where rid between 5 and 10
-- order by CityId
Eralper