Cursor-based pagination for SQL Server

sqlserver-cursor-based-pagination.sql

-- The ID value of the last row from the previous page.
DECLARE @Cursor NVARCHAR(100) = '19';

-- The number of rows you want for the next page.
DECLARE @PageSize INT = 10;

WITH [Query] AS (
    SELECT * FROM dbo.ProductModel
)
SELECT * FROM [Query]
ORDER BY Id ASC 
OFFSET(
    SELECT TOP 1 [RowNumber]
    FROM(
        SELECT 
            [Id]
            ,ROW_NUMBER() OVER (ORDER BY ID ASC) AS [RowNumber]
        FROM [Query]
    ) [Temp]
    WHERE [Temp].Id = @Cursor
) ROWS
FETCH NEXT @PageSize ROWS ONLY