What is the role of UNION ALL and UNION
The UNION command eliminates the duplicates and the UNION ALL command retains the duplicates while combining the results of the different SELECT statements.
BY Best Interview Question ON 09 Feb 2019
The UNION command eliminates the duplicates and the UNION ALL command retains the duplicates while combining the results of the different SELECT statements.