Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.

Name: Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.
Brand: Quizplus
Rating: 4.9 (34 reviews)

Question

Columns used to group data in the GROUP BY clause must also be listed in the SELECT clause.​

Quizplus · Accepted Answer

Columns used in the GROUP BY clause do not need to be listed in the SELECT clause unless they are part of the output. Aggregate functions can be used in the SELECT clause to summarize the grouped data.

Columns Used to Group Data in the GROUP BY Clause