Which is default sorting option in SQL ORDER BY clause?

 Posted by CGN007 on 6/14/2012 | Category: Sql Server Interview questions | Views: 5106 | Points: 40
Select from following answers:
  1. ASC
  2. DESC
  3. There is no default value.
  4. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Gemamgall on: 6/27/2012 | Points: 10
Default sorting order is ASC and in order to retrieve values in descending order we have to write order by clause
Posted by: Krishnamsai on: 5/20/2013 | Points: 10
ORDER BY Keyword sorts the records in Ascending order by default.
To sort the records in Descending order use the keyword DESC.

Login to post response