使用：
SELECt CASE WHEN COUNT(*) = (SELECT COUNT(*) FROM a) AND COUNT(*) = (SELECt COUNT(*) FROM b) THEN 'Elements in TableA and TableB contains identical sets' ELSE 'TableA and TableB do NOT contain identical sets' END FROM (SELECt a.col FROM a INTERSECT SELECt b.col FROM b) x
测试：
WITH a AS ( SELECt 'a' AS col UNIOn ALL SELECT 'b' UNIOn ALL SELECT 'c' UNIOn ALL SELECT 'd'), b AS ( SELECT 'b' AS col UNIOn ALL SELECT 'c' UNIOn ALL SELECT 'd' UNIOn ALL SELECT 'a')SELECT CASE WHEN COUNT(*) = (SELECT COUNT(*) FROM a) AND COUNT(*) = (SELECt COUNT(*) FROM b) THEN 'yes' ELSE 'no' END FROM (SELECt a.col FROM a INTERSECT SELECt b.col FROM b) x
