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