What is the difference between union and union all in Teradata?
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