UNION ALL combines two or more result sets into a single set, including all duplicate rows. INTERSECT takes the rows from both the result sets which are common in both. EXCEPT takes the rows from the first result data but does not in the second result set.

What is the difference between UNION and INTERSECT?

The union of two sets contains all the elements contained in either set (or both sets). … The intersection of two sets contains only the elements that are in both sets.

What is difference between UNION and MINUS in SQL?

It returns a union of two select statements. It is returning unique (distinct) values of them. Similar to UNION just that UNION ALL returns also the duplicated values. MINUS (also known as EXCEPT) returns the difference between the first and second SELECT statement.