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 SUM, COUNT, AVG in SQL's SELECT clause, non-aggregated columns must be included in a GROUP BY clause. This groups rows before aggregation. WHERE filters rows before grouping, ORDER BY sorts results after aggregation. The 'Aggregate Function' option is not a clause.

Keep practicing — related questions