What The Difference Between Union And Union All?

1.	What The Difference Between Union And Union All?
Answer» UNION will REMOVE the duplicate ROWS from the result SET while Union all does'nt. Union will remove the duplicate rows from the result set while Union all does'nt.

Answer»

UNION will REMOVE the duplicate ROWS from the result SET while Union all does'nt.

Union will remove the duplicate rows from the result set while Union all does'nt.

Discussion