Software & Finance





SQL - What is the difference between UNION and UNION ALL Statements?





What is the difference between UNION and UNION ALL Statements?

 

Both used to combine the result of two select statement queries. UNION will list only the distinct value, but UNION ALL will list all values, even if there are duplicates.