oracle paging 代码

来源:互联网 发布:js base64 utf8 编辑:程序博客网 时间:2024/05/16 07:47
 SELECT *
  FROM (SELECT ROWNUM rnum, emp.*
          FROM (SELECT   empno, ename, job, mgr, hiredate, sal, comm, deptno
                    FROM emp
                ORDER BY empno DESC) emp)
 WHERE rnum >= 1 AND rnum <= 10
原创粉丝点击