DECLARE @PageNumber AS INT, @RowspPage AS INT
SET @PageNumber = 6
SET @RowspPage = 5
SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY id) AS NUMBER,
* FROM tableType
) AS TBL
WHERE NUMBER BETWEEN ((@PageNumber - 1) * @RowspPage + 1) AND (@PageNumber * @RowspPage)
ORDER BY id