Listing 5: INTERSECT ALL Query SELECT col1, col2 FROM (SELECT col1, col2, MIN(cnt) AS mincnt FROM (SELECT col1, col2, COUNT(*) AS cnt FROM U GROUP BY col1, col2 UNION ALL SELECT col1, col2, COUNT(*) FROM V GROUP BY col1, col2) AS D1 GROUP BY col1, col2 HAVING COUNT(*) > 1) AS D2 JOIN Nums ON n <= mincnt