ORACLE 分页查询基本模式

查询 一段 rownum记录
   select *
            from (select row_.*, rownum rownum_
                   from ( ) row_
            where rownum <= 10)
           where rownum_ > 0 
            and  --其他查询条件

 

 查询 指定rownum记录

select * from (select row_.*, rownum rownum_ from (select empid
  from A a ) row_ where rownum <= 10) where rownum_ = 10