Multiple choice technology databases

State true or false All the columns in the column clause of select statment that are not in a group function must be listed in the group by clause.However,a column listed in group by clause needn't appear in column clause

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL, any column in SELECT that isn't inside an aggregate function (like COUNT, SUM, AVG) must appear in GROUP BY. This ensures each row in the result represents a unique group. The reverse isn't required - a column can be in GROUP BY without being selected.