ocp 11g認證考試題庫：051-117題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp 11g認證考試題庫：051-117題，完整題庫請點擊這里聯系老師咨詢了解
117. Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
(Choose all that apply.)
A. The HAVING clause can be used with aggregate functions in subqueries.
B. The WHERE clause can be used to exclude rows after dividing them into groups.
C. The WHERE clause can be used to exclude rows before dividing them into groups.
D. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list
of the query.
E. The WHERE and HAVING clauses can be used in the same statement only if they are applied to
different columns in the table.
Answer: AC
試題解析：
A,having可以用在聚合函數的子句里。正確
B,分組之后不能使用where來限制，因為where只能限制行，不能限制組，錯誤
C,分組之前可以使用where來限制所要輸出的行，正確
D,在having子句的聚合函數或者字段不一定要在select列表中，錯誤。
E,在同一句子中，where和having可以都使用，可以應用在不同的字段，也可以相同的字段。
