【資料名稱】：sql

【資料作者】：mwy

【資料日期】：2012-8-8

【資料語言】：中文

【資料格式】：TXT

【資料目錄和簡介】：

Select
decode(substr(bsc.name,1,2),'KM','KM','QJ','QJ','QU','QJ','YU','YX','YX','YX','BN','BN','BS','BS','DH','DH','DE','DH','LC','LC','LI','LC','SM','SM','SI','SM','XG','DL','DL','DL','CX','CX','CH','CX','HH','HH','HO','HH','others') area
,c_bts.cell_id
,bts.object_instance bts
,decode(bts.freq_band_in_use,0,'900基站',1,'1800基站',2,'GSM1900',5,'GSM800','NotDefined')BAND
,class_upper_range-110 upper_range
,Sum(freq_ul_qual0) ulq0
,Sum(freq_ul_qual1) ulq1
,Sum(freq_ul_qual2) ulq2
,Sum(freq_ul_qual3) ulq3
,Sum(freq_ul_qual4) ulq4
,Sum(freq_ul_qual5) ulq5
,Sum(freq_ul_qual6) ulq6
,Sum(freq_ul_qual7) ulq7
,Sum(freq_dl_qual0) dlq0
,Sum(freq_dl_qual1) dlq1
,Sum(freq_dl_qual2) dlq2
,Sum(freq_dl_qual3) dlq3
,Sum(freq_dl_qual4) dlq4
,Sum(freq_dl_qual5) dlq5
,Sum(freq_dl_qual6) dlq6
,Sum(freq_dl_qual7) dlq7
from p_nbsc_rx_statistics, c_bts, objects bsc,objects bts,objects bcf
where
p_nbsc_rx_statistics.int_id=bsc.int_id
and p_nbsc_rx_statistics.bts_int_id=c_bts.int_id
and bts.parent_int_id = bcf.int_id
and bcf.parent_int_id = bsc.int_id
and c_bts.int_id=bts.int_id
--and decode(substr(bsc.name,1,2),'KM','KM','QJ','QJ','QU','QJ','YU','YX','YX','YX','BN','BN','BS','BS','DH','DH','DE','DH','LC','LC','LI','LC','SM','SM','SI','SM','XG','DL','DL','DL','CX','CX','CH','CX','HH','HH','HO','HH','others')
and c_bts.cell_id in (&ci)
and c_bts.conf_name='<ACTUAL>'
and to_char(period_start_time,'hh24') In (8,9,10,18,19,20)
and period_start_time>=to_date(&start_date,'yyyymmdd')
and period_start_time<to_date(&end_date,'yyyymmdd')
group by
decode(substr(bsc.name,1,2),'KM','KM','QJ','QJ','QU','QJ','YU','YX','YX','YX','BN','BN','BS','BS','DH','DH','DE','DH','LC','LC','LI','LC','SM','SM','SI','SM','XG','DL','DL','DL','CX','CX','CH','CX','HH','HH','HO','HH','others')
,c_bts.cell_id
,bts.object_instance
,decode(bts.freq_band_in_use,0,'900基站',1,'1800基站',2,'GSM1900',5,'GSM800','NotDefined')
,class_upper_range-110
order by area,c_bts.cell_id,upper_range--