Phân trang đơn giản trên SQL

DECLARE @UpperBand int, @LowerBand int

SET @LowerBand  = (1 - 1) * 10
SET @UpperBand  = (1 * 10)
SELECT * FROM (
SELECT d.PostId ,
ROW_NUMBER() OVER(ORDER BY d.Id DESC) AS RowNumber
FROM Photo d
where PostId is null
) AS temp
WHERE RowNumber > @LowerBand AND RowNumber <= @UpperBand;