If a group function is used in the WHERE clause,then any individual columns listed in the SELECT clause must also be listed in the GROUP BY clause.

Question

If a group function is used in the WHERE clause,then any individual columns listed in the SELECT clause must also be listed in the GROUP BY clause.​

Quizplus · Accepted Answer

Group functions cannot be used in the WHERE clause directly. The WHERE clause is used to filter rows before they are grouped, and group functions operate on the grouped rows. To filter based on a group function, the HAVING clause is used instead. Individual columns in the SELECT clause do not necessarily need to be in the GROUP BY clause if they are used within a group function.

If a Group Function Is Used in the WHERE Clause,then