Lesson 8.1 · Pro
UNION and UNION ALL
Stack the results of two queries on top of each other.
In this lesson
- UNION ALL keeps every row
- UNION removes duplicates
Go Pro to read this lesson
Pro unlocks every lesson and practice problem in SQL, Python, pandas and NumPy, with answers and step-by-step explanations.