Computer Science
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.
SQL Joins & Grouping
2 Likes
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.
Answered By
3 Likes
Related Questions
You can specify any type of condition, using any comparison operator in an equi-join.
Join can only be created from two tables.
Assertion. A GROUP BY query can also include functions.
Reason. ALL SQL functions can be used in a GROUP BY query.
Assertion. SQL SELECT query can also fetch rows from multiple tables.
Reason. A join is a query that combines rows from two or more tables.