oracle 分页例子

select tp_card_num,serial,result,login_area,phone_number,tp_account_amount,cust_name from
(
  select rownum rn,tp_card_num,serial,result,login_area,phone_number,tp_account_amount,cust_name from
  (
select t.tp_card_num as tp_card_num,t.serial as serial ,t.result as result,t.login_area as login_area ,t.phone_number as phone_number,t.tp_account_amount as tp_account_amount,t.cust_name as cust_name from netb_pay_on_line t where (t.tp_card_num='银联支付'
or t.tp_card_num='建设银行' or t.tp_card_num='农业银行' or t.tp_card_num='招商银行') and  t.date_and_time between (to_date('2009-05-01' ,' yyyy-mm-dd' ))  and  (to_date('2009-05-20' ,' yyyy-mm-dd' )+1) and t.login_area in('290', '910', '911', '912','913','914', '915', '916','917', '919') order by t.date_and_time desc
   )

 where rownum <=100
   )  where rn>50