OCP-1Z0-051 第117题 WHERE和HAVING子句的区别

一、原题

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.

答案：AC

二、题目翻译

关于WHERE和HAVING子句哪句话是正确的(选择所有正确的选项）
A.HAVING子句能在子查询中使用聚合函数。
B.WHERE子句能被用于在划分组之后排除行。
C.WHERE子句能被用于在划分组之前排除行。
D.用在HAVING子句中的聚合函数和列必须被指定到SELECT语句的列表中。
E.只要应用不同的列，WHERE和HAVING子句就能用在相同的语句中。

三、题目解析

WHERE是在分组之前筛选数据，HAVING是在分组之后筛选数据。
WHERE子句中不能使用聚合函数，HAVING子句中可以使用聚合函数。