Distinguish between UNION and UNION ALL.

1.	Distinguish between UNION and UNION ALL.
Answer» To aggregate the results of TWO or more SQL SELECT QUERIES, we USE the SQL UNION method. In the union operation, the number of data types and columns in both tables on which the UNION action is performed must be the same. Duplicate rows are REMOVED from the result set by the UNION operation. Union ALL operation is the same as a Union operation. It returns the set without sorting the data or DELETING duplicates.

Discussion