SQL: 分页SQL SQL2005函数分页!

DECLARE
@pagenum INT,
@pagesize INT
SET @pagenum = 2
SET @pagesize = 3
SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY b DESC) AS rownum,c FROM a) AS D
WHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize
ORDER BY rownum DESC