SELECT
*
FROM
(
SELECT
ROW_NUMBER() OVER ( ORDER BY [columns] ) AS RowNum, *
FROM
[tablename]
WHERE [whereclause]
) AS RowConstrainedResult
WHERE
RowNum >= [startrownumber]
AND RowNum < [endrownumber]
ORDER BY RowNum;