Oracle/PLSQL: ORA-00937 Error
Error: |
ORA-00937: not a single-group group function |
Cause: |
You tried to execute a SELECT statement that included a GROUP BY function (ie: MIN, MAX, SUM, COUNT), but was missing the GROUP BY clause. |
Action: |
The options to resolve this Oracle error are:
For example, if you had tried to execute the following SELECT statement:
You would receive the following error message:
You could correct this by including department in the GROUP BY clause as follows:
|
