oracle分页查询

利用ROWNUM截取结果集中的部分数据，需要用到行内视图
SELECT *
FROM (SELECT ROWNUM rn,e.* FROM emp e)
WHERE rn BETWEEN 8 AND 10;

利用ROWNUM分页：三层SELECT 嵌套

SELECT * FROM
(
SELECT ROWNUM rn, t.* FROM
(SELECT ename, job ,sal FROM emp ORDER BY sal DESC）t
)
WHERE rn BETWEEN 8 AND 10;

=============================

select * from
(select a.*,rownum rn FROM
    (select * from ET_HD_TASK task order by TASK.ETHT_ID) a

)
where rn<=10;

where rn between 1 and 10;

where  rn>0 and  rn<=10;   备注：rn>0 或rn>=0 或rn>=1        <=10  表示的都是十条记录。

转载于:https://www.cnblogs.com/21heshang/p/5981455.html