诺西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