hemant kumar
What is the use of DESC in SQL?
1 Answer(s)      5 years and 8 months ago
Posted in : SQL

What is the use of DESC in SQL?

Advertisement
View Answers

November 18, 2010 at 6:20 PM


Hi,

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.

Thanks.










Advertisement