What is the use of DESC in SQL?

Question

Hello member,

What is the use of DESC in SQL?

please reply me .........i m waiting for ur reply

Answer 1

DESC has two purposes. It is used to describe a schema as well as to retrieve rows from table in descending order.

Explanation :
The query SELECT * FROM EMP ORDER BY ENAME DESC will display the output sorted on ENAME in descending order.