with maxPCI(PCI) as
(select TOP (5) percent PHYCELLID
from tbCell
order by PHYCELLID desc
)
select Avg(PCI)
from maxPCI
从数据库中选取前5个最大值,并计算均值
最新推荐文章于 2024-05-06 02:16:03 发布
with maxPCI(PCI) as
(select TOP (5) percent PHYCELLID
from tbCell
order by PHYCELLID desc
)
select Avg(PCI)
from maxPCI