A to Z Exams

Question

**What does the DESC keyword do in the following query? SELECT * FROM MY_TABLE WHERE ID > 0 ORDER BY ID, NAME DESC**

A. It causes the dataset returned by the query to be sorted in descending order

B. It causes rows with the same ID to be sorted by NAME in ascending order

D. It causes rows to be sorted by NAME first and then by ID

E. It causes the result set to include a description of the NAME field

View Answer

1

Correct Answer :
It causes rows with the same ID to be sorted by NAME in descending order

Explanation :
No Explanation available for this question

Answer 1

C. It causes rows with the same ID to be sorted by NAME in descending order