DWQA QuestionsCategory: SQLIf we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default
Editor Staff asked 9 months ago

If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default

  1. DESC
  2. ASC
  3. There is no default value
  4. None of the mentioned
1 Answers
Editor Staff answered 9 months ago

2-ASC
Explanation: If we have not specified any sorting with the ORDER BY clause, SQL always uses the ASC as a default sorting order. SQL treats Null as the lowest possible values while sorting.