Which MySQL clause used with the query SELECT* FROM PACKAGE would be the most likely to yield the following results?
A) WHERE PACKAGE_NAME DESC, PRICE
B) WHERE PRICE DESC, PACKAGE_NAME
C) ORDER BY PACKAGE_NAME, PRICE DESC
D) ORDER BY PRICE DESC, PACKAGE_NAME

Question

Quizplus · Accepted Answer

The correct clause to use in order to sort the results first by PRICE in descending order and then by PACKAGE_NAME in ascending order (as a secondary sort criterion) is "ORDER BY PRICE DESC, PACKAGE_NAME". The "ORDER BY" clause is used for sorting the results of a SELECT query in SQL, not the "WHERE" clause, which is used for filtering records.

Which MySQL Clause Used with the Query SELECT* FROM PACKAGE