Oracle
1Z0-071 · Question #10
Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.)
The correct answer is A. WHERE and HAVING clauses cannot be used together in a SQL statement. D. The WHERE clause is used to exclude rows before the grouping of 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
Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.)
Options
- AWHERE and HAVING clauses cannot be used together in a SQL statement.
- BThe HAVING clause conditions can have aggregate functions.
- CThe HAVING clause conditions can use aliases for the columns.
- DThe WHERE clause is used to exclude rows before the grouping of data.
- EThe HAVING clause is used to exclude one or more aggregated results after grouping data.
How the community answered
(36 responses)- A81% (29)
- B8% (3)
- C11% (4)
Community Discussion
No community discussion yet for this question.