Question · SQL and MySQL course · Module 8: Subqueries

UNION ALL

How does UNION ALL differ from UNION?

Answer options

  • UNION ALL is slower because it additionally sorts the results
  • UNION ALL keeps all rows, including duplicates
  • UNION ALL returns only duplicates
  • UNION ALL combines columns instead of rows

You can check the correct answer by solving this task in the CodeWorlds game.