A SELECT statement cannot include both a GROUP BY and an ORDER BY clause.

Question

A SELECT statement cannot include both a GROUP BY and an ORDER BY clause.​

Quizplus · Accepted Answer

A SELECT statement can include both a GROUP BY and an ORDER BY clause. The GROUP BY clause is used to group the result set by one or more columns, while the ORDER BY clause is used to sort the result set by one or more columns. However, it is important to ensure that the columns used in the ORDER BY clause are also included in the GROUP BY clause or in an aggregate function, otherwise an error will occur.

A SELECT Statement Cannot Include Both a GROUP BY and an ORDER