Oracle 分页查询

【记录一下】

1、查询表中最早的前10行数据

select a.* 
    from 
        ( 
           select t.*,rownum AS RN 
            from eap_autostack_log t 
              order by t.id  
         ) a 
where RN<11;

2、查询表中最新的前10行数据

SELECT * 
     FROM (    
            SELECT B.*,ROWNUM RN2 
            FROM  
                (  
                  SELECT ROWNUM RN1,A.* 
                  FROM TABLE_NAME A order by a.id desc
                 ) B 
            ) 
       WHERE ROWNUM<11;