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
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

Answer 1

______✨ HEY MATE ✨_____

➡️Option (B) is the right answer ✔️

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

$<marquee>✌️ I THINK IT HELPED YOU ✌️$

Answer 2

The correct option is, (B) It causes rows with the same ID to be sorted by NAME in ascending order.

What is  DESC keyword?

• The keyword DESC in SQL, is used to sort the query result set in a descending order.

• The ASC keyword is used to sort the query result set in an ascending order.

What is DESC keyword in SQL?

• The DESC command is used to sort the data returned in descending order.

What does DESC table mean in SQL?

• So desc or describe command shows the structure of table which include name of the column, data-type of column and the nullability which means, that column can contain null values or not.

Hence, For queries, the DESC keyword is used. It causes all rows with the same ID to be sorted in ascending order by NAME.

Learn more about DESC keyword here,  https://brainly.in/question/12931200?msp_poc_exp=5

#SPJ2