Oracle
1Z0-061 · Question #299
Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose all that apply.)
The correct answer is A. The HAVING clause can be used with aggregate functions in subqueries. C. The WHERE clause can be used to exclude rows before dividing them into groups. See the full explanation below for the reasoning.
Question
Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose all that apply.)
Options
- AThe HAVING clause can be used with aggregate functions in subqueries.
- BThe WHERE clause can be used to exclude rows after dividing them into groups.
- CThe WHERE clause can be used to exclude rows before dividing them into groups.
- DThe aggregate functions and columns used in the HAVING clause must be specified in the
- EThe WHERE and HAVING clauses can be used in the same statement only if they are applied to
How the community answered
(60 responses)- A78% (47)
- B5% (3)
- D3% (2)
- E13% (8)
Community Discussion
No community discussion yet for this question.