PLS-00604: aggregate function is not allowed here

PLS-00604: aggregate function is not allowed here
Cause: One of the functions, such as AVG, COUNT, MAX, MIN, SUM, STDDEV or VARIANCE, was used in a WHERE or GROUP BY clause
Action: Remove the group function from the WHERE or GROUP BY clause. The desired result may be achieved by including the function in a subquery or HAVING clause.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 19:02

PLS-00604：这里不允许聚合函数,
.原因：其中一个功能，如AVG，COUNT，MAX，MIN，SUM，STDDEV或VARIANCE，在WHERE或GROUP BY子句中使用,
.操作：从WHERE或GROUP BY子句中删除组函数。可以通过在子查询或HAVING子句中包含该函数来实现所需的结果。,
.

aiaiDBA

13718043309

010-86462881

PLS-00604: aggregate function is not allowed here

1 个回答

相似问题