Question

Which clause is used to sort query elements?

(a) GROUP

(b) GROUP BY

(c) ORDER

(d) ORDER BY

I got this question in a national level competition.

The origin of the question is MySQL Setup topic in division General MySQL Use of MySQL

Answer 1

Correct answer is (d) ORDER BY

The explanation is: An ‘ORDER BY’ clause specifies the sort order. The data is sorted in ascending order by default. To sort in descending order, the keyword DESC is appended to the ‘ORDER BY’ clause. ‘GROUP BY’ is used to group the query results according to the criteria.