Which of the following is the correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field?
A) SORT BY Department
B) REVERSE Department
C) ORDER BY Department DESC
D) SORT BY Department DESC
E) SORT BY Department REVERSE

Question

Quizplus · Accepted Answer

The correct SQL clause to sort the results of a SELECT query in reverse-alphabetic order using the Department field is ORDER BY Department DESC. This sorts the results in alphabetical order of the Department field in descending order (i.e., reverse-alphabetic order). The other options are not valid SQL clauses for sorting data in this way.

Which of the Following Is the Correct SQL Clause to Sort