UNION : eliminates duplicates UNION ALL: retains duplicates Both these are used to combine the results of different SELECT statements .
UNION ALL: retains duplicates
Both these are used to combine the results of different SELECT statements.