ROWNUM-Oracle中的分页代码

SELECT * FROM 
 (SELECT ENAME,SAL,ROWNUM RN FROM EMP WHERE ROWNUM <= @CURRENTPAGE*@PAGESIZE) SUB 
 WHERE SUB.RN > (@CURRENTPAGE-1)*5;