发布时间 : 星期四 文章诺西LTE指标提取SQL语句20160801更新完毕开始阅读
and b.co_parent_gid=c.co_gid and adjl.conf_id=1 and lncel.conf_id=1
and cel.co_parent_gid=c.co_gid and lncel.obj_gid=cel.co_gid and cel.co_oc_id=2881 and c.co_oc_id=2860 and a.co_state=0 and b.co_state=0 and c.co_state=0 and cel.co_state=0 --and d.co_oc_id=3130
-- and c.co_object_instance=235280
--- and ((c.co_object_instance between 233472 and 236031) or (c.co_object_instance between 241664 and 244735))
8. --小区低噪查询
select a.period_start_time
,bts.co_object_instance enodeb_id ,cel.co_object_instance ci_config ,cell.LNCEL_LCR_ID cell_id ,a.RSSI_PUSCH_AVG ,a.RSSI_PUCCH_MIN ,a.RSSI_PUCCH_MAX ,a.RSSI_PUSCH_MIN ,a.RSSI_PUSCH_MAX
from
Noklte_Ps_LPQUL_Mnc1_Raw a ,ctp_common_objects bts ,ctp_common_objects cel ,c_lte_lncel cell where
bts.co_oc_id=2860
and cel.co_parent_gid=bts.co_gid and a.LNCEL_ID=cel.co_gid and cell.obj_gid=cel.co_gid and cell.conf_id='1'
and a.period_start_time>=to_date(&start_date,'yyyymmddhh24') and a.period_start_time 48 620568, 620569, 620596, 620865, 620595 ) group by a.period_start_time ,bts.co_object_instance ,cel.co_object_instance ,cell.LNCEL_LCR_ID ,a.RSSI_PUCCH_MIN ,a.RSSI_PUCCH_MAX ,a.RSSI_PUSCH_AVG ,a.RSSI_PUSCH_MIN ,a.RSSI_PUSCH_MAX order by a.period_start_time 49