UNION

How can we combine employee and contractor names into one deduplicated list?

Advanced⏱ 3 Minutes⭐ 1740 XP

🤔 THE QUESTION

How can we combine employee and contractor names into one deduplicated list?

💡 WHAT IS IT?

UNION combines rows from two queries and automatically eliminates duplicate rows.

🎯 WHAT IS IT USED FOR?

Combining rosters, unique customer lists across channels, merged contact lists.

💻 EXAMPLE

SELECT name
FROM employees
UNION
SELECT name
FROM contractors;

Practice typing production-grade SQL code for UNION.