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.