Which of the following is a valid statement?
A) The ORDER BY clause cannot be used in a SELECT statement containing a GROUP BY clause.
B) Data returned from a GROUP BY clause will automatically be sorted in descending order.
C) Column aliases cannot be used in a GROUP BY clause.
D) Columns referenced in the GROUP BY clause must also be contained in the SELECT clause.

Question

Which of the following is a valid statement?​
A) ​The ORDER BY clause cannot be used in a SELECT statement containing a GROUP BY clause.
B) ​Data returned from a GROUP BY clause will automatically be sorted in descending order.
C) ​Column aliases cannot be used in a GROUP BY clause.
D) ​Columns referenced in the GROUP BY clause must also be contained in the SELECT clause.

Quizplus · Accepted Answer

Column aliases cannot be used in a GROUP BY clause because the GROUP BY clause is processed before the SELECT clause, where aliases are defined.

Which of the Following Is a Valid Statement?​

Which of the Following Is a Valid Statement?