update c_tpa_sts_cell_ne a set dropcall_rate_delta=(dropcall_rate)/(select distinct decode(dropcall_rate,0,1,dropcall_rate) from c_tpa_sts_cell_ne where scan_start_time=to_date('2009-10-11 14:0:0','yyyy-mm-dd hh24.mi:ss')-1/24 and int_id=a.int_id and int_id is not null)-1
where scan_start_time='2009-10-11 14:0:0';
update c_tpa_sts_cell_ne a set dropcall_delta=(dropcall)/(select distinct decode(dropcall,0,1,dropcall) from c_tpa_sts_cell_ne where scan_start_time=to_date('2009-10-11 14:0:0','yyyy-mm-dd hh24.mi:ss')-1/24 and int_id=a.int_id and int_id is not null)-1
where scan_start_time='2009-10-11 14:0:0';
update c_tpa_sts_cell_ne a set block_rate_delta=(block_rate)/(select distinct decode(block_rate,0,1,block_rate) from c_tpa_sts_cell_ne where scan_start_time=to_date('2009-10-11 14:0:0','yyyy-mm-dd hh24.mi:ss')-1/24 and int_id=a.int_id and int_id is not null)-1
where scan_start_time='2009-10-11 14:0:0';
update c_tpa_sts_cell_ne a set succ_rate_delta=(succ_rate)/(select distinct decode(succ_rate,0,1,succ_rate) from c_tpa_sts_cell_ne where scan_start_time=to_date('2009-10-11 14:0:0','yyyy-mm-dd hh24.mi:ss')-1/24 and int_id=a.int_id and int_id is not null)-1
where scan_start_time='2009-10-11 14:0:0';
就是利用这个表和上个小时的增量比率来得到本小时的值
|