当你看错题又不想重新做于是疯狂打补丁belike: 2025-10-20 作者 Gzz 求差集方法: -- 简洁明了,兼容性好 SELECT * FROM A WHERE id NOT IN (SELECT id FROM B) UNION ALL SELECT * FROM B WHERE id NOT IN (SELECT id FROM A);