What does the DESC keyword do in the following query SELECT...

This question belongs to PHP Databases Handling

Databases Handling

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 C) It causes rows with the same ID to be sorted by NAME in descending 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

Answer & Solution

Correct Answer: Option C

Let's discuss the solution. Join the discussion

Question posted by Examveda

Community

Join the Discussion

Join the discussion

No comments yet Be the first to discuss this question.

Keep Learning

What does the DESC keyword do in the following query SELECT...

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

Join the Discussion

Related Questions on Databases Handling

What does the DESC keyword do in the following query?

`SELECT * FROM MY_TABLE WHERE ID > 0 ORDER BY ID, NAME DESC"`