Stepwise-Lab

ORA-00979: Not a GROUP BY expression

Every expression in the SELECT list (and in HAVING and ORDER BY) that is not inside a group function must appear in GROUP BY. Oracle never picks an arbitrary value for you.

On the exam

This error belongs to the topic Aggregation of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors