The SQL UNION operator combines the result sets of two SELECT queries and removes duplicates.
The SQL UNION ALL operator combines result sets and keeps duplicate rows.