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.

Suggest An Answer

No suggestions avaliable!