Oracle
1Z0-082 · Question #90
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
The correct answer is C. The HAVING clause can be used with aggregating functions in subqueries D. The WHERE clause can be used to exclude rows before dividing them into groups. You've hit your weekly limit · resets 5am (America/New_York)
SQL and PL/SQL
Question
Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
Options
- AAggregating functions and columns used in HAVING clauses must be specified in the SELECT
- BWHERE and HAVING clauses can be used in the same statement only if applied to different table
- CThe HAVING clause can be used with aggregating functions in subqueries
- DThe WHERE clause can be used to exclude rows before dividing them into groups
- EThe WHERE clause can be used to exclude rows after dividing them into groups
How the community answered
(28 responses)- A7% (2)
- B14% (4)
- C75% (21)
- E4% (1)
Explanation
You've hit your weekly limit · resets 5am (America/New_York)
Topics
#WHERE clause#HAVING clause#GROUP BY#aggregate functions
Community Discussion
No community discussion yet for this question.