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

Опубликовано: 10 Март 2023
на канале: java frm

571

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