ORA-00937: not a single-group group function - Oracle Database 12c Error Messages

Channel:

java frm

Subscribers:

5,740

Published on March 11, 2023 7:34:30 AM ● Video Link: https://www.youtube.com/watch?v=H_X3JnVvgCo

Duration: 1:26

4 views

0

In this video we are going to see how to fix below Oracle Database 12c Error Message.

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.

#12c #oracledatabase12c #oracledatabase #oracledba #sql #oraclesql #oraerrors #oracleerrorcodes #dba #database