Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  
 

What is the use of DESC in SQL?

Ads

 
 

Share on Google+Share on Google+

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

What is the use of DESC in SQL?

Ads
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.


Ads