페이징

DECLARE @pagenum AS INT, @pagesize AS INT
SET @pagenum  = 1
SET @pagesize = 10

SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY REG_DATE ASC) AS rownum, *
      FROM M_USERINFO) AS D
WHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize
ORDER BY REG_DATE ASC

GO