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

Grouping Records, Joins in SQL — Question 1

Back to all questions
1
Question

Question 1

Assertion. SQL SELECT's GROUP BY clause is used to divide the result in groups.

Reason. The GROUP BY clause combines all those records that have identical values in a particular field or in group by fields.

Answer

(a)

Both Assertion and Reason are true and Reason is the correct explanation of Assertion.

Explanation
The GROUP BY clause combines all those records that have identical values in a particular field or a group of fields. This clause is utilised in SELECT statements to divide the result set into groups based on the values in the specified columns. Grouping can be done by a column name, or with aggregate functions in which case the aggregate produces a value for each group.