Who makes the cut in both lists?

Question

Accepted Answer

INTERSECT returns only rows that appear in both result sets. Bob and Carol are in both tables; Alice is only in table_a; Dave is only in table_b. Like UNION, INTERSECT removes duplicates from the result. INTERSECT ALL keeps duplicates - if Bob appeared twice in each table, he would appear twice in the result.