You are not logged in.
- Topics: Active | Unanswered
Pages:: 1
#1 2015-04-22 07:11:32
- 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.
Offline
2015-04-22 07:11:32
- Advertisement
- Ads By Google
Re: WHERE And HAVING Clauses:
\n
Pages:: 1