What is the use of DESC 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 Tutorials/Questions & Answers:
Advertisements

Questions by Category