Question

Keyword “ASC” and “DESC” cannot be used without which clause in Mysql?

(a) ORDER BY

(b) GROUP BY

(c) SELECT

(d) HAVING

The question was posed to me by my college professor while I was bunking the class.

This question is from The order by Clauses in section Select Statement of MySQL

Answer 1

Right option is (a) ORDER BY

The best explanation: “ASC” or “DESC” are used to sort the result set in ascending or descending order therefore they cannot be used without “ORDER BY” clause.