Question - Explain UNION, MINUS, UNION ALL, INTERSECT?
Answer -
INTERSECT returns all distinct rows selected by both queries.
MINUS: returns all distinct rows selected by the first query but not by the second.
UNION: returns all distinct rows selected by either query
UNION ALL: returns all rows selected by either query, including all duplicates