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

Role of the second column in ORDER BY

Why do you give a second column in ORDER BY, e.g. ORDER BY kraj ASC, nazwisko ASC?

Answer options

  • It breaks ties - when the first column is the same, the second decides
  • It makes sorting twice as fast
  • The second column is always ignored
  • It joins both columns into one piece of text
Show the answer

Correct answer:

  • It breaks ties - when the first column is the same, the second decides