【資料名稱】：C__Users_HP_AppData_Local_Temp_Abis口尋呼量

【資料作者】：nsn

【資料日期】：2008

【資料語言】：中文

【資料格式】：DOC

【資料目錄和簡(jiǎn)介】：

Select
Day
,bsc_name
,lac
,Max(pgn_msg) pgn_msg
From
(select to_char(m.period_start_time,'yyyymmdd') Day
,to_char(m.period_start_time,'hh24') hr
,bsc.name bsc_name
,c_bts.la_id_lac lac
,Avg(m.paging_msg_sent) pgn_msg
,Avg(m.delete_paging_command) del
,Sum(m.succ_seiz_term) term
,Count(*) bts_count
from c_bts, p_nbsc_res_access m, objects bts, objects bsc, objects bcf
whereperiod_start_time >= to_date(&start_date,'yyyymmdd')
and period_start_time < to_date(&end_date,'yyyymmdd')
and bts.object_class=4
and bsc.object_class=3
and bcf.object_class=27
and bcf.parent_int_id=bsc.int_id
and bts.parent_int_id=bcf.int_id
and m.ave_rach_slot!=0
and m.bts_int_id = bts.int_id
and c_bts.int_id = m.bts_int_id
and c_bts.CONF_NAME = '<ACTUAL>'
group by bsc.name,c_bts.la_id_lac,to_char(m.period_start_time,'yyyymmdd'),to_char(m.period_start_time,'hh24')
)
Group By
Day
,bsc_name
,lac
;