嗨，我有以下代码，在这些代码中，我尝试获取飞机ID（aircraftid）和服务的次数（count（serviceid）），但仅在count（serviceid）大于平均数量时才显示它们。 count（serviceid）。
select aircraftid, s.times
from(
select aircraftid, count(serviceid) as times
from service
group by aircraftid
) as s
having times > avg(times);
但是当我运行它时，它不返回任何行
当我将代码更改为
select aircraftid, s.times
from(
select aircraftid, count(serviceid) as times
from service
group by aircraftid
) as s
having times > 2;
它返回行
您可以尝试-
SELECT aircraftid,
COUNT(serviceid) AS times
FROM service
GROUP BY aircraftid
HAVING COUNT(serviceid) > (
SELECT AVG(T) FROM
(
SELECT count(serviceid) T
FROM service
GROUP BY aircraftid
)A
)
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句