Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 3 of 78

Simple Queries in SQL — Question 3

Back to all questions
3
Question

Question 3

Assertion. The WHERE and HAVING clauses are used for the same thing in a SELECT query.

Reason. Both WHERE and HAVING clauses are used to specify conditions at different levels.

Answer

(d)

Assertion is false but Reason is true.

Explanation
The WHERE and HAVING clauses are not used for the same thing in a SELECT query. While both WHERE and HAVING clauses are used to specify conditions in a SELECT query, they operate at different levels. The WHERE clause filters rows based on conditions applied to individual rows before grouping, while the HAVING clause filters groups based on conditions applied to the result of aggregation functions after grouping.