What does the DESC keyword do in the following query?SELECT * FROM MY_TABLE WHERE ID > 0 ORDER BY ID, NAME DESC Options: A . &nbspIt causes rows with the same ID to be sorted by NAME in descending order B . &nbspIt causes rows with the same ID to be sorted by NAME in ascending order C . &nbspIt causes the result set to include a description of the NAME field D . &nbspIt causes the dataset returned by the query to be sorted in descending order

What does the DESC keyword do in the following query?SELECT * FROM MY

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

Options:

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

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

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

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

Answer: Option A

Submit Your Solution Below and Earn Points !

Next Question