Q30
Keyword "ASC" and "DESC" cannot be used without which clause in Mysql?
A.
ORDER BY
AnswerB.
GROUP BY
C.
SELECT
D.
HAVING
Answer: Option A
Solution
Answer: Option A
Solution:
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.