解决方式有2种:
from语句中子查询
根据路测ATU数据表,查询服务小区参考信号接收功率RSRP的均值大于-70的小区。
select cellid, avg_rsrp
from ( select cellid, AVG(rsrp)
from tbATUData
group by CellID) as T(cellid, avg_rsrp)
where avg_rsrp > -70
select语句中子查询
根据小区/基站工参表和一阶邻区关系表,列出频点为38400的所有小区的一阶邻区数目。
select sector_id, earfcn,
(select COUNT(N_SECTOR_ID)
from tbAdjCell
where S_SECTOR_ID = SECTOR_ID) as adjNum
from tbCell
where earfcn = 38400