{"description":"\u30c6\u30fc\u30d6\u30eb\u52d5\u8a5e\u306e\u6bd4\u8f03\uff11(EXCEPT) ALL\u306a\u3057\u306f\u91cd\u8907\u6392\u9664 \u30c6\u30fc\u30d6\u30eb\u540c\u58eb\u306e\u6bd4\u8f032(UNION\u30fbINTERSECT\uff09 \u53c2\u8003\u66f8\u7c4d \u30c6\u30fc\u30d6\u30eb\u52d5\u8a5e\u306e\u6bd4\u8f03\uff11(EXCEPT) EXCEPT \u5dee\u96c6\u5408\u3002\u4e0b\u56f3\u306e\u30c6\u30fc\u30d6\u30eb5\u3068\u30c6\u30fc\u30d6\u30eb\uff16\u3067\u8a66\u3057\u3066\u307f\u308b\u3002 \u30c6\u30fc\u30d6\u30eb5 \u30c6\u30fc\u30d6\u30eb6 \u300cA EXCEPT B\u300d\u3068\u300cB EXCEPT A\u300d\u306eSQL\u3092\u5b9f\u884c\u3057\u3066\u3001\u4e21\u65b9\u3068\u3082\u7d50\u679c\u304cNULL\u306a\u3089\u540c\u3058\u8981\u7d20\u306e\u30c6\u30fc\u30d6\u30eb\u3068\u8a00\u3048\u308b\u3002 --table5 - table6 SELECT * FROM test.table5 EXCEPT ALL SELECT * FROM test.table6; --table6 - table5 SELECT * F\u2026","type":"rich","blog_title":"okinawa","url":"https://dodosu.hatenablog.jp/entry/2023/03/05/000940","title":"\u3010SQL\u3011\u30c6\u30fc\u30d6\u30eb\u540c\u58eb\u306e\u6bd4\u8f03","categories":[],"provider_name":"Hatena Blog","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/d/dodosu/20230304/20230304234336.png","version":"1.0","width":"100%","height":"190","author_url":"https://blog.hatena.ne.jp/dodosu/","author_name":"dodosu","blog_url":"https://dodosu.hatenablog.jp/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fdodosu.hatenablog.jp%2Fentry%2F2023%2F03%2F05%2F000940\" title=\"\u3010SQL\u3011\u30c6\u30fc\u30d6\u30eb\u540c\u58eb\u306e\u6bd4\u8f03 - okinawa\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2023-03-05 00:09:40","provider_url":"https://hatena.blog"}