DECLARE @PAGEINDEX INTDECLARE @PAGESIZE INTSET @PAGEINDEX=1SET @PAGESIZE=50SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY CNO_CODE) AS ROWNUM,CNO_CODEFROM ODMDOC ) AS DWHERE ROWNUM BETWEEN (@PAGEINDEX-1)*@PAGESIZE+1 AND @PAGEINDEX*@PAGESIZEORDER BY CNO_CODE
