Class - 12 CBSE Computer Science — Assertion Reason Type Questions
Assertion. The GROUP BY clause yields summary results using group functions.
Reason. The GROUP BY clause combines a number of rows in a group and applies functions on it.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
SQL Queries
1 Like
Answer
Both A and R are true and R is the correct explanation of A.
Explanation
The GROUP BY
clause yields summary results using group functions because it combines all records that have identical values in a particular field or a group of fields. This grouping results in one summary record per group if group functions are used with it.
Answered By
2 Likes