Tag Archives: ORA-00937

ORA-00937: not a single-group group function

ORA-00937: not a single-group group function

ORA-00937: not a single-group group function
Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause
Action: Drop either the group function or the individual column expression from the SELECT list or add a GROUP BY clause that includes all individual column expressions listed

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/