ORA-00978 : nested group function without GROUP BY

Email This Post Email This Post

Cause : A group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, was used within another group function, as in MAX(COUNT(*)), without a corresponding GROUP BY clause.
Action : Either add a GROUP BY clause or remove the extra level of nesting.

Popularity: 4% [?]

Related Post

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

Close
E-mail It