Which of the following statements describes the use of a GROUP BY clause?
A GROUP BY clause returns a single row of information for each group of rows.
Correct:
A GROUP BY clause returns a single row of information for each group of rows.
Answer: D
Answer option C is incorrect. The GROUP BY clause only returns a single row of information for each group of rows. It does not return information for all the rows.
Answer option B is incorrect. The GROUP BY clause does not sort the results in ascending or descending order. The ORDER BY clause is used with the GROUP BY command to sort the result in desired order.
Answer option A is incorrect. The ORDER BY clause used with the GROUP BY clause sorts the grouped result in desired order.