Question

Which clause amongst the following can be used along with aggregate functions?

• A. Select
• B. Group by
• C. Where
• D. Both Select and Group by

Hint:

To perform aggregation on grouped data, always use GROUP BY along with SELECT to define which columns are used for aggregation.

Answer 1

The Correct Option is D

Aggregate functions such as COUNT, SUM, AVG, etc., can be used with the SELECT and GROUP BY clauses in SQL. GROUP BY groups rows that have the same values in specified columns into summary rows, which is essential when using aggregate functions.