复制select  vmhr.v_mo,同表图方   vmhr.org_code,   case decode(sign(to_char(sysdate,hh24)-to_char(report_time,hh24)),-1,to_char  (sysdate,hh24)-to_char(report_time,hh24)+24,to_char(sysdate,hh24)-to_char(report_time,hh24)) when 1 then (select decode(nvl(send_num,0),0,null,nvl(success_num,0)/nvl(send_num,1)) from channel_flux where v_mo=vmhr.v_mo) end last_1_suss_rate,   case decode(sign(to_char(sysdate,hh24)-to_char(report_time,hh24)),-1,to_char(sysdate,hh24)-to_char(report_time,hh24)+24,to_char(sysdate,hh24)-to_char(report_time,hh24)) when 2 then (select decode(nvl(send_num,0),0,null,nvl(success_num,0)/nvl(send_num,1)) from channel_flux where v_mo=vmhr.v_mo) end last_2_suss_rate,   case decode(sign(to_char(sysdate,hh24)-to_char(report_time,hh24)),-1,to_char(sysdate,hh24)-to_char(report_time,hh24)+24,to_char(sysdate,hh24)-to_char(report_time,hh24)) when 3 then (select decode(nvl(send_num,0),0,null,nvl(success_num,0)/nvl(send_num,1)) from channel_flux where v_mo=vmhr.v_mo) end last_3_suss_rate   from channel_flux vmhr   1.2.3.4.5.6.7.8.