Class - 12 CBSE Computer Science — Assertion Reason Type Questions
Assertion. A GROUP BY query can also include functions.
Reason. ALL SQL functions can be used in a GROUP BY query.
SQL Joins & Grouping
2 Likes
Answer
(c)
Assertion is true but Reason is false.
Explanation
A GROUP BY query can include functions. This is true because SQL allows the use of aggregate functions like COUNT(), SUM(), etc., within a GROUP BY query to perform calculations on grouped data. However, it's important to note that not all SQL functions can be used within a GROUP BY query. Only aggregate functions or functions that operate on grouped data can be used effectively in this context.
Answered By
2 Likes