Question

在oracle中，我的group by语句

SELECT FAMILYNAME_EN,
CASE WHEN SUM(COUNT(CONFIRM_IND)) > SUM(COUNT(ATHLETE_ID)) and SUM(COUNT(CONFIRM_IND)) = 0 then 'Open'
WHEN SUM(COUNT(CONFIRM_IND)) > SUM(COUNT(ATHLETE_ID)) and SUM(COUNT(CONFIRM_IND)) < 0 then 'In Progress'
ELSE 'Close' end as STATUS
FROM HKG_DIST_ATHLETE GROUP BY FAMILYNAME_EN,CONFIRM_IND
为什么这样会报“不是单组分组函数”

Answer 1

使用group by 的时候select后只能使用group by字段或者聚合函数。你用case这样是不行的。