SELECT *, COUNT(*) FROM t1 GROUP BY x, y, z, ... -- all attributes of t1 EXCEPT SELECT *, COUNT(*) FROM t2 GROUP BY x, y, z, ... -- all attributes of t2