| Author |
question for 1Z0-007 ORACLE SQL:?
|
|
| jksaviyo 2005-07-28, 2:48 pm |
| This is an exam question for 1Z0-007 ORACLE SQL:
Could you verify the answer is A or B. Because of my observation –
Exclude group results clause is WHERE,
Include group results clause is HAVING
Which clause should you use to exclude group results?
A. WHERE
B. HAVING
C. RESTRICT
D. GROUP BY
E. ORDER BY
Ans: | |
| bytes_avila 2005-07-28, 10:46 pm |
| i think you answer is correct. you can only use having clause when group by clause exist , while where clause is just a condition you can exclude it still with ha group by clause | |
| jksaviyo 2005-08-05, 12:50 pm |
| The answer is HAVING.
In the text book says” Excluding Group Results: The HAVING Clause”, the HAVING clause to restrict groups.
If we translate the meaning of “Excluding” then it will confuse, that was happened to me. |
|
|
|