Examveda
Examveda

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: Option C


This Question Belongs to PHP >> Databases Handling

Join The Discussion

Related Questions on Databases Handling