CBSE Class 12 Computer Science Question 53 of 91

Grouping Records, Joins in SQL — Question 9

Back to all questions
9
Question

Question 9

The HAVING and WHERE clauses are interchangeable.

Answer

False

Reason — The HAVING clause places conditions on groups in contrast to WHERE clause that places conditions on individual rows. While WHERE conditions cannot include aggregate functions, HAVING conditions can include aggregate functions. Hence, WHERE and HAVING clauses cannot be used interchangeably in queries.