【资料名称】：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) "主小区电平",
round(a.STD_DEV_OF_SERV_CELL, 2) "主区标准差",
round(a.AVE_DL_SIG_STR_ADJ_CELL, 2) "邻区平均电平",
a.NCC "邻区NCC",
a.BCC "邻区BCC",
a.BCCH "邻区BCCH",
round(a.STD_DEV_OF_ADJ_CELL, 2) "邻区标准差",
a.NBR_OF_SAMPLES_IN_CLASS_1 "邻区电平等级1数",
a.NBR_OF_SAMPLES_IN_CLASS_2 "邻区电平等级2数",
a.NBR_OF_SAMPLES_IN_CLASS_3 "邻区电平等级3数"
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