What is the difference between UNION and UNION ALL?
What is the difference between UNION and UNION ALL? 2 22 UNION removes duplicate records (where all columns in the results are the same), UNION ALL does not. There is a performance hit when using UNION instead of UNION ALL, since the database server must do additional work to remove the duplicate rows, but usually … Read more