oracle分页查询(查询第五到第十五条数据),分步解析
1,select * from t_emp;
2,select e1.*,rownum rn from ((select * from t_emp) e1);
3,select e1.*,rownum rn from ((select * from t_emp) e1) where rownum<=15;
4,select * from (select e1.*,rownum rn from ((select * from t_emp) e1) where rownum<=15) where rn>=5;