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

 
 


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

What is the use of DESC in SQL?

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 Pages:

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.