Practice
White Room
Community
Tools
What is the difference between UNION and UNION ALL?
There is no difference
UNION allows duplicate rows, UNION ALL removes them
UNION removes duplicate rows, UNION ALL keeps them
UNION is faster than UNION ALL
Sign in to answer questions and track your progress