1
SQLIntermediate#sets
SQLBeginner#sets
UNION vs UNION ALL?
Both stack two result sets with matching column counts and types. UNION removes duplicate rows (needs a sort/hash, slower); UNION ALL returns everything as-is and is faster.
Example
SELECT city FROM customers UNION -- distinct cities SELECT city FROM suppliers; SELECT city FROM customers UNION ALL -- keeps duplicates SELECT city FROM suppliers;