ORA-00934 group function is not allowed here
What causes an ORA-00934 error?
One of the group functions, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, was used in a WHERE or GROUP BY clause.
How Xynomix can help
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.
Contact us for more information. To learn more about ways we can support your database visit our Oracle database consultancy page.
On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.