Question: what is the difference between intersect and union in sql?
Answer: UNION ALL: Combine two or more result sets into a single set, including all duplicates. INTERSECT: Takes the data from both result sets which are in common. EXCEPT: Takes the data from the first result set, but not in the second result set (i.e. no matching to each other)