Oracle
1Z0-071 · Question #103
Which two statements are true regarding the SQL GROUP BY clause?
The correct answer is D. Using the WHERE clause before the GROUP BY clause excludes rows before creating groups. E. If the SELECT clause has an aggregating function, then columns without an aggregating function. See the full explanation below for the reasoning.
Question
Which two statements are true regarding the SQL GROUP BY clause?
Options
- AYou can use a column alias in the GROUP BY clause.
- BUsing the WHERE clause after the GROUP BY clause excludes rows after creating groups.
- CThe GROUP BY clause is mandatory if you are using an aggregating function in the SELECT
- DUsing the WHERE clause before the GROUP BY clause excludes rows before creating groups.
- EIf the SELECT clause has an aggregating function, then columns without an aggregating function
How the community answered
(49 responses)- A12% (6)
- B2% (1)
- C4% (2)
- D82% (40)
Community Discussion
No community discussion yet for this question.