Consulta ROW_NUMBER()

[Libras]

Código SQL:

SELECT P.ProductID, P.ProductName, C.CategoryName, P.UnitPrice, contact.RowNumber
    FROM 
    ( 
            SELECT P.ProductName,
            ROW_NUMBER() OVER (ORDER BY P.ProductID) AS RowNumber
            FROM Products AS P
    ) AS Contact,
    Categories AS C,
    Products AS P
WHERE P.CategoryID = C.CategoryID
    AND contact.RowNumber BETWEEN 11 AND 20
 

Prueba asi :)

Saludos!