当你看错题又不想重新做于是疯狂打补丁belike:

求差集方法:
-- 简洁明了,兼容性好
SELECT * FROM A WHERE id NOT IN (SELECT id FROM B)
UNION ALL
SELECT * FROM B WHERE id NOT IN (SELECT id FROM A);

发表评论