What is the use of DESC in SQL?

 Posted by Abhisek on 1/21/2010 | Category: Sql Server Interview questions | Views: 2251

DESC is used to describe a schema as well as to retrieve rows from table in descending order.

The query SELECT * FROM Student ORDER BY SNAME DESC will display the output sorted on SNAME in descending order.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response