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)      7 years 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









Ads

 
Advertisement null

Ads