WITH DemoTableName AS
(
SELECT ROW_NUMBER() OVER (Order by ColumnName ) as RowNumber,* from TableName
)
SELECT *FROM DemoTableName WHERE RowNumber between beginPageNbr and endPageNbr