Which three statements are true regarding the SQL WHERE and HAVING clauses?

The correct answer is C. The WHERE and HAVING clauses cannot be used together in a SQL statement. D. The WHERE clause is used to exclude rows before grouping data. E. The HAVING clause is used to exclude one or more aggregated results after grouping data. See the full explanation below for the reasoning.

Question

Options

AThe HAVING clause conditions can have aggregating functions.
BThe HAVING clause conditions can use aliases for the columns.
CThe WHERE and HAVING clauses cannot be used together in a SQL statement.
DThe WHERE clause is used to exclude rows before grouping data.
EThe HAVING clause is used to exclude one or more aggregated results after grouping data.

How the community answered

(42 responses)

A
17% (7)
B
7% (3)
C
76% (32)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice