What Is Union,union All?

1.	What Is Union,union All?
Answer» UNION : ELIMINATES duplicates UNION ALL: RETAINS duplicates Both these are USED to COMBINE the results of different SELECT statements. UNION : eliminates duplicates UNION ALL: retains duplicates Both these are used to combine the results of different SELECT statements.

Answer»

UNION : ELIMINATES duplicates
UNION ALL: RETAINS duplicates
Both these are USED to COMBINE the results of different SELECT statements.

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

Discussion