oracle 分页

分页时要与order by 配合！！！

select F003D_0042, F008V_0042,F007N_0042,OB_RECTIME_0042,OB_TEXTID_0042,F002D_0042,F004V_0042 
from (select rownum rn,F003D_0042, F008V_0042,F007N_0042,OB_RECTIME_0042,OB_TEXTID_0042,F002D_0042,F004V_0042 
 	 from (select
    	   max(F003D_0042) F003D_0042, 
    	   max(F008V_0042) F008V_0042,
    	   max(F007N_0042) F007N_0042,
    	   max(OB_RECTIME_0042) OB_RECTIME_0042,
    	   OB_TEXTID_0042,
    	   max(F002D_0042) F002D_0042,
    	   max(F004V_0042) F004V_0042 
           FROM TB_TEXT_0042 a,TB_TEXT_0045 b
    	   WHERE ob_rectime_0042 >= to_date('2013-03-26 00:00:00','yyyy-mm-dd hh24:mi:ss') and ob_rectime_0042 < to_date('2014-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')
    	   and a.OB_TEXTID_0042=b.OB_TEXTID_0045 
    	   and F001V_0045 IN ('QDII','LOF','ETF','老基金','开放式基金','封闭式基金')
           and b.ob_seccode_0045 is not null
           group by OB_TEXTID_0042
    	   order by OB_TEXTID_0042
    	   )
     ) 
where rn > 0 and rn < 100