When do you need to use the GROUP BY clause in the SELECT statement? Please choose the correct answer.

When do you need to use the GROUP BY clause in the SELECT statement? Please choose the correct answer.
A . If you want to use aggregate functions and all components in the field list are aggregate functions
B . If you want to use ORDER BY to specify a sub-order
C . If you want to redefine the sequence of the columns in the result set
D . If you want to use aggregate functions and at least one component in the field list is a column identifier

View Answer

Answer: D