SELECT * FROM (SELECT ENAME,SAL,ROWNUM RN FROM EMP WHERE ROWNUM <= @CURRENTPAGE*@PAGESIZE) SUB WHERE SUB.RN > (@CURRENTPAGE-1)*5;
Oracle中的分页代码
原文：http://www.cnblogs.com/kuillldan/p/5881159.html
