SQL UNION

How can we combine rows from two queries and remove duplicate values?

Advanced⏱ 3 Minutes⭐ 400 XP

🤔 THE QUESTION

How can we combine rows from two queries and remove duplicate values?

💡 WHAT IS IT?

UNION combines result sets from multiple SELECT statements and deduplicates identical rows.

🎯 WHAT IS IT USED FOR?

Merging customer lists, combining full-time and freelance workers into a single unique roster.

💻 EXAMPLE

SELECT name
FROM employees
UNION
SELECT name
FROM contractors;

Practice typing production-grade SQL code for SQL UNION.