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

Querying Using SQL — Question 3

Back to all questions
3
Question

Question 3

Assertion. The GROUP BY clause can use any type of function.

Reason. The GROUP BY clause combines a number of rows in a group and applies functions on it.

  1. Both A and R are true and R is the correct explanation of A.
  2. Both A and R are true but R is not the correct explanation of A.
  3. A is true but R is false.
  4. A is false but R is true.
Answer

A is false but R is true.

Explanation
The GROUP BY clause uses aggregate functions. It combines all those records that have identical values in a particular field or a group of fields and applies group-functions, resulting in one summary record per group.