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

1 Like

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


Related Questions