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