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

A. ORDER BY

B. GROUP BY

C. SELECT

D. HAVING

Answer: Option A

Solution(By Examveda Team)

In MySQL, the keywords "ASC" (ascending) and "DESC" (descending) are used in conjunction with the "ORDER BY" clause to specify the sorting order of the query results. The "ORDER BY" clause arranges the rows returned by a query based on the values of one or more columns. Therefore, the keywords "ASC" and "DESC" cannot be used without the "ORDER BY" clause. Hence, Option A is correct.