Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 37 of 90

Querying Using SQL — Question 15

Back to all questions
15
Question

Question 15

Which clause is used with "aggregate functions" ?

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

GROUP BY

Reason — Aggregate functions (such as COUNT, SUM, AVG, MAX, MIN) are used with the GROUP BY clause to perform operations on each group of rows. The GROUP BY clause groups rows that have the same values in specified columns into summary rows.