Computer Science
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.
SQL Queries
2 Likes
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.
Answered By
1 Like
Related Questions
Assertion. There is a difference between a field being empty or storing NULL value in a field.
Reason. The NULL value is a legal way of signifying that no value exists in the field.
Assertion. The ALL and DISTINCT clauses of a SELECT query are related.
Reason. The ALL clause is the opposite of the DISTINCT clause of a SELECT Query.
Assertion. Both WHERE and HAVING clauses are used to specify conditions.
Reason. The WHERE and HAVING clauses are interchangeable.
Assertion. DDL and DML are not the same.
Reason. DDL and DML are two subcategories of SQL where DDL creates the objects and DML manipulates the data.