Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-00934: group function is not allowed here
Oracle® Database Error ORA-0093417/5

ORA-00934: group function is not allowed here

Cause: You tried to execute a SQL statement that included one of the SQL group functions, ie: SQL MIN(), MAX(), SUM(), COUNT(), AVG(), STDDEV(), or VARIANCE() in either the SQL WHERE clause or the SQL GROUP BY clause. This is not allowed.

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 SQL HAVING clause.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle