What is the difference between UNION and UNION ALL? Technology Community › Category: SQL › What is the difference between UNION and UNION ALL? 0 Vote Up Vote Down VietMX Staff asked 5 years ago UNION operation returns only the unique records from the resulting data set UNION ALL will return all the rows, even if one or more rows are duplicated to each other.
VietMX