Returns distinct rows by comparing the results of two queries.
EXCEPTreturns distinct rows from the left input query that aren't output by the right input query.
INTERSECTreturns rows that are returned by both input queries.
The below examples use long_sequence(n) to generate a list of integers from 1 to n.
Returns rows unique to the left query. In this case, integers from 6 to 10
long_sequence(10) EXCEPT long_sequence(5);
Returns rows output by both queries. In this case, integers from 1 to 5
long_sequence(10) INTERSECT long_sequence(5);