【資料名稱】：NSN的SQL語句

【資料作者】：流浪

【資料日期】：20111208

【資料語言】：中文

【資料格式】：其它

【資料目錄和簡介】：

select a.period_start_time time,
a.PERIOD_DURATION "測量周期",
a.int_id,
o.name BSC,
c.la_id_lac LAC,
c.cell_id CI,
a.DB_VALUE_LOW "低門限值",
a.DB_VALUE_HIGH "高門限值",
round(sum(a.AVE_DL_SIG_STR_SERV_CELL_SUM) /
nullif(sum(a.AVE_DL_SIG_STR_SERV_CELL_DEN), 0),
2) "主小區(qū)電平",
round(a.STD_DEV_OF_SERV_CELL, 2) "主區(qū)標準差",
round(a.AVE_DL_SIG_STR_ADJ_CELL, 2) "鄰區(qū)平均電平",
a.NCC "鄰區(qū)NCC",
a.BCC "鄰區(qū)BCC",
a.BCCH "鄰區(qū)BCCH",
round(a.STD_DEV_OF_ADJ_CELL, 2) "鄰區(qū)標準差",
a.NBR_OF_SAMPLES_IN_CLASS_1 "鄰區(qū)電平等級1數(shù)",
a.NBR_OF_SAMPLES_IN_CLASS_2 "鄰區(qū)電平等級2數(shù)",
a.NBR_OF_SAMPLES_IN_CLASS_3 "鄰區(qū)電平等級3數(shù)"
from p_nbsc_def_adj_cell a, c_bts c, objects o
where a.int_id = o.int_id
and a.bts_int_id = c.int_id
and c.conf_name = '<ACTUAL>'
and a.period_start_time = trunc(sysdate) - 1 + 19 / 24and c.cell_id='20141'
/* between trunc(sysdate-1)+18/24 and trunc(sysdate-1)+20/24*/
group by a.period_start_time,
a.PERIOD_DURATION,
a.int_id,
o.name,
c.la_id_lac,
c.cell_id,
a.DB_VALUE_LOW,
a.DB_VALUE_HIGH,
a.STD_DEV_OF_SERV_CELL,
a.AVE_DL_SIG_STR_ADJ_CELL,
a.NCC,
a.BCC,
a.BCCH,
a.STD_DEV_OF_ADJ_CELL,
a.NBR_OF_SAMPLES_IN_CLASS_1,
a.NBR_OF_SAMPLES_IN_CLASS_2,
a.NBR_OF_SAMPLES_IN_CLASS_3
order by c.cell_id