Which clause is used in a MySQL query to sort the result set in descending…
2026
Which clause is used in a MySQL query to sort the result set in descending order based on a specific column?
- A.
SORT BY... DESC
- B.
ORDER BY... DESC
- C.
SORT BY... DSC
- D.
ORDER BY... DSC
Attempted by 539 students.
Show answer & explanation
Correct answer: B
To sort a result set in descending order based on a specific column in MySQL, use the ORDER BY clause followed by the column name and the DESC keyword. For example: SELECT * FROM table_name ORDER BY column_name DESC.