Week | 3 Complete Data Analytics | Question 1

When using the GROUP BY clause in SQL, what must be included in the SELECT statement?

(A)

All columns in the table

(B)

Only columns used in the GROUP BY clause

(C)

Only aggregated columns

(D)

All columns used in the GROUP BY clause and aggregated columns

Answer: (D)
Explanation:

When using the GROUP BY clause, the SELECT statement must include all columns specified in the GROUP BY clause and any aggregated columns.

Quiz of this Question
Please comment below if you find anything wrong in the above post