SAP
C_TAW12_731 · Question #12
When do you need to use the GROUP BY clause in the SELECT statement?
The correct answer is D. If you want to use aggregate functions and at least one component in the field list is a column identifier. See the full explanation below for the reasoning.
Question
When do you need to use the GROUP BY clause in the SELECT statement?
Options
- AIf you want to redefine the sequence of the columns in the result set
- BIf you want to use aggregate functions and all components in the field list are aggregate functions
- CIf you want to use ORDER BY to specify a sub-order
- DIf you want to use aggregate functions and at least one component in the field list is a column identifier
How the community answered
(32 responses)- A3% (1)
- B9% (3)
- C3% (1)
- D84% (27)
Community Discussion
No community discussion yet for this question.