ORA-00937: not a single-group group function tips

Home
E-mail Us
Oracle Articles
New Oracle Articles

Oracle Training
Oracle Tips
Oracle Forum
Class Catalog

Remote DBA
Oracle Tuning
Emergency 911
RAC Support
Apps Support
Analysis
Design
Implementation
Oracle Support

SQL Tuning
Security
Oracle UNIX
Oracle Linux
Monitoring
Remote support
Remote plans
Remote services
Application Server
Applications
Oracle Forms
Oracle Portal
App Upgrades
SQL Server
Oracle Concepts
Software Support
Remote Support
Development
Implementation

Consulting Staff
Consulting Prices
Help Wanted!

Oracle Posters
Oracle Books
Oracle Scripts
Ion
Excel-DB

Don Burleson Blog

ORA-00937: not a single-group group function tips

Oracle Error Tips by Burleson Consulting

Oracle docs note this about ORA-00937:

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.

Here is another example of a user encountering ORA-00903 from the OraFAQ forums:

Question:

I am trying to use a function that I created which will calculate my customer's bills, including discounts.

However, every time I try to use the function, I receive ORA-00903. Any suggestions?

Answer:

You are missing the GROUP BY clause in your function. Try to take the SQL out and run it in SQL*Plus until it works again. ORA-00937 can probably be detected during compile, but even if the function shows that it has been compiled, errors such as ORA-00937 may still be thrown.

Also, ORA-00937 may be occurring because of your SELECT clause. Note that COUNT() and SUM() have to be grouped by all members in the SELECT clause.

��