Multiple choice technology databases

When the 'SELECT' clause of the SQL has the aggregate function, it is must to have this clause to prevent error

  1. WHERE

  2. ORDER BY

  3. GROUP BY

  4. Aggregate Function
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When using aggregate functions like COUNT, SUM, or AVG in the SELECT clause, non-aggregated columns must be included in a GROUP BY clause. This groups rows by those columns before aggregation. WHERE filters rows before grouping, while ORDER BY sorts results after aggregation.

Keep practicing — related questions