Question

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

(a) ORDER BY

(b) GROUP BY

(c) SELECT

(d) HAVING

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.