Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL What is the use of DESC in SQL?

Have Programming Question? Ask it here!
 
 
 


hemant kumar
What is the use of DESC in SQL?
1 Answer(s)      3 years and 9 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.



Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com