UNION - Combining Query Results1 / 10
The
Notice which rows belong to both tables, and whether they appear as duplicates in the result (hint: they don't).
UNION operator combines the results of multiple queries and removes duplicates. Try:SELECT title FROM action_movies UNION SELECT title FROM scifi_movies;
Notice which rows belong to both tables, and whether they appear as duplicates in the result (hint: they don't).
Ctrl+Enter to submit
UNION - Combining Query Results - Free SQL Practice Online
Practise UNION - Combining Query Results with 10 free, interactive SQL exercises. You type real queries into your browser and get instant feedback on every answer - no database setup, no install, and no signup. It is a fast, hands-on way to learn SQL online and build query skills you can use at work.