Question

Where and Having clauses can be used interchangeably in SELECT queries.
a) True b) False c) With Order by. d) Only in views​

Answer 1

Answer:

False

Explanation:

HAVING clause is like a WHERE clause, but applies only to groups as a whole (that is, to the rows in the result set representing groups), whereas the WHERE clause applies to individual rows. A query can contain both a WHERE clause and a HAVING clause but cannot be interchanged.