Question · SQL and MySQL course · Module 2: Querying data (SELECT)

Default sort direction

What is the default sort direction when you give neither ASC nor DESC in ORDER BY?

Answer options

  • Descending (DESC) - from largest to smallest
  • Random
  • None - you must always give a direction
  • Ascending (ASC) - from smallest to largest
Show the answer

Correct answer:

  • Ascending (ASC) - from smallest to largest