All errors › ORA errors
ORA-00937: Not a single-group group function
What it means
The SELECT list mixes aggregate functions (SUM, COUNT, MAX...) with plain columns, but there is no GROUP BY.
How to fix it
Add every non-aggregated column of the SELECT list to GROUP BY, or use an analytic function (SUM(x) OVER ()) if you want the total next to each row.
Catch it before it runs
ORA Error Helper
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Explains ORA-/PLS- codes inside JetBrains IDEs and DataGrip. PL/SQL Lint
Flags risky PL/SQL patterns while you type. Oracle Plan Reader
Reads execution plans and points at the slow step. PL/SQL in Practice
Kindle book with practical PL/SQL for working developers.
Nearby errors
Updated 2026-11-12.