Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 39 of 90

Querying Using SQL — Question 17

Back to all questions
17
Question

Question 17

Where and Having clauses can be used interchangeably in SELECT queries ?

  1. True
  2. False
  3. Only in views
  4. With order by
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 SELECT queries.