Oracle Database SQL Certified Associate Exam

Which statement about the GROUP BY clause is TRUE?

Columns in SELECT not in an aggregate must appear in GROUP BY GROUP BY must always be followed by HAVING NULL values cannot appear in a GROUP BY column GROUP BY eliminates duplicate rows without aggregation

Correct Answer:

Columns in SELECT not in an aggregate must appear in GROUP BY

Access more questions from this quiz

Continue to Oracle Database SQL Certified Associate Exam for more practice questions and the full quiz experience.

Access More Questions