Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 27 of 91

Grouping Records, Joins in SQL — Question 5

Back to all questions
5
Question

Question 5

Which clause is used with "aggregate functions" ?

  1. GROUP BY
  2. SELECT
  3. WHERE
  4. Both (1) and (3)
Answer

GROUP BY, SELECT

Reason — Aggregate functions are used with the GROUP BY clause to perform calculations on groups of rows. However, they are also used in the SELECT clause to display the results of aggregate calculations.