ERROR: column ... must appear in the GROUP BY clause or be used in an aggregate function

Reason:

A query omitted a non-aggregate expression in its GROUP BY clause.

Resolution:

Group by all non-aggregate expressions.

Tips:

  • Include all non-aggregate expressions in a GROUP BY clause
Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk