SQL Keyword - DESC

In this blog, we learn about SQL Keyword - DESC

DESC Keyword

The DESC keyword or command is used to sort the data in descending order.

We have specified the column sort order using the DESC keyword.

Syntax

SELECT * FROM <TABLE_NAME> ORDER BY <COLUMN_NAME> DESC;

Example 1

SELECT * FROM Employee ORDER BY Emp_Name DESC;

Example 2 

SELECT * FROM Employee ORDER BY Emp_Name DESC,Emp_Salary DESC;

Summary

The DESC keyword helps us sort the results in descending order.