What does the DESC keyword do in the following query?
SELECT *
FROM MY_TABLE
WHERE ID > 0
ORDER BY ID, NAME DESC
It causes rows with the same ID to be sorted by NAME in descending order
Correct:
It causes rows with the same ID to be sorted by NAME in descending order
Explanation:
Answer C is correct. The DESC keyword is used to reverse the default sorting mechanism applied to a column. In this case, therefore, it will cause the rows to be first sorted by ID and then by NAME in descending order.