Question

Which key word is used to sort the records of a table in descending order?

Answer 1

Answer:

DESC key word is used to sort the records of a table in descending order.

Explanation:

The ‘ORDER BY’ clause has been used for sorting the result records in ascending order or descending order. In default, the ‘order by sorts’ the record in ascending orders. Or else we can use ASC keyword. In order to sort the records in ‘descending order’, DESC keyword is used in ‘ORDER BY’ clause. The syntax is provided below as follows,

SELECT col 1, col 2, …

FROM table name

ORDER BY col 1, col 2, …. ASC / DESC;