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

Category: SQLIf we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default
Editor">Editor Staff asked 2 years 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">Editor Staff answered 2 years 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.