我要执行此查询：
Select Environment, SUM(Scores) as `Scores`,SUM(Clicks) as `Clicks`
from Example.table
where Scores > sum(Scores)
group by Environment
但这会引发以下错误：
[4:27]的WHERE子句中不允许聚合函数SUM
而在拥有：的情况下，having Scores > sum(Scores)我无法保留Scores。什么是实现此目标的正确方法？
您的查询应如下所示：
Select Environment
,Scores
,SUM(Scores) as `Scores`
,SUM(Clicks) as `Clicks`
from TABLE
group by Environment, Scores
HAVING (Scores > sum(Scores))
您还需要包括得分和分组依据（即使您不需要）。
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句