What is the SQL keyword used to sort the result set in descending order?OptionsSORTDESCASCORDER

Answer

The SQL keyword used to sort the result set in descending order is DESC.

When you execute a query and need the results sorted in a specific order, you typically use the ORDER BY clause. To sort the results in descending order, you would append DESC to the column name in the ORDER BY clause.

For example, if you want to sort a table by a column named age in descending order, the SQL query would look like this:

SELECT * FROM your_table
ORDER BY age DESC;

In this context, SORT, ASC, and ORDER are not valid keywords for this purpose. SORT and ORDER are generally not used in standard SQL syntax, while ASC is used for ascending order sorting, which is the opposite of what is requested.

Therefore, the correct option is DESC.