What is the difference between UNION and UNION ALL?


#1

Question

What is the difference between UNION and UNION ALL?

Answer

When combining data from multiple tables, UNION will remove duplicates in the resulting table (ie. rows where the values in all selected columns are the same), whereas UNION ALL will not.