Computer Science
With GROUP BY, the select-list of the SELECT statement can only take the group-field and/or aggregate function.
SQL Joins & Grouping
3 Likes
Answer
True
Reason — When using the GROUP BY clause in SQL, the select-list of the SELECT statement can only include the grouping columns (group-fields) and/or aggregate functions. MySQL would not produce any error even if we include a non-group field in the select-list. However, it will return the value from first record of the group for that non-group field.
Answered By
3 Likes