Interview Questions And Answers Forum

alisiddiqui

Banned

Registered: 2015-02-23

Posts: 949

WHERE And HAVING Clauses:

Question:
What is the difference between the WHERE and HAVING SQL clauses?

Option A):
The HAVING SQL clause condition(s) is applied to all rows in the result set before the WHERE clause is applied (if present). The WHERE clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.
Option B):
The WHERE and the HAVING clauses are identical
Option C):
The WHERE SQL clause condition(s) is applied to all rows in the result set before the HAVING clause is applied (if present). The HAVING clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.

Correct Answer is Option C):
The WHERE SQL clause condition(s) is applied to all rows in the result set before the HAVING clause is applied (if present). The HAVING clause is used only with SELECT SQL statements and specifies a search condition for an aggregate or a group.