The UNION operator in SQL combines the results of two or more SELECT statements into a single result set. It removes duplicate rows by default. Each SELECT statement must have the same number of columns in the same order and with compatible data types.
Example
SELECT name, email FROM employees
UNION
SELECT name, email FROM contractors;
This combines names and emails from both tables, excluding duplicates. Use UNION ALL to include duplicates.
