S.no Union Union All
1. It removes duplicate records where all columns in the results are the same. It doesn’t remove duplicate records where all columns in the results are the same.
2. The performance will be impacted with the use of Union as additional work will be performed to remove duplicate rows. The performance will not be impacted.
BY Best Interview Question ON 06 Mar 2019