SQL DMLｼ夊､蜷亥撫縺蜷医ｏ縺(UNION)
讎りｦ
髮蜷域ｼ皮ｮ怜ｭ
UNION
UNION ALL
MINUS/EXCEPT
INTERSECT
繧堤畑縺縺ｦ隍謨ｰ縺ｮ蝠上＞蜷医ｏ縺帙ョ繝ｼ繧ｿ繧堤ｵ縺ｿ蜷医ｏ縺帙ｋ蝠上＞蜷医ｏ縺
繝ｻ蛻励ｮ謨ｰ縲√ョ繝ｼ繧ｿ蝙九ｂ蜷後§縺ｧ縺ゅｋ蠢隕√′縺ゅｋ縲
窶ｻ繧ｵ繧､繧ｺ縲∝怜錐縺ｯ驕輔▲縺ｦ縺縺ｦ繧り憶縺縲
繝ｻORDER BY蜿･縺ｯ隍蜷亥撫縺蜷医ｏ縺帛縺ｮ譛蠕後↓1蝗槭□縺第欠螳壼庄閭ｽ縲
繝ｻ譛蛻昴ｮSELECT譁縺ｮ蛻怜錐縺瑚｡ｨ遉ｺ縺輔ｌ繧九
窶ｻ譛蛻昴ｮSELECT譁縺ｮ蛻怜錐繧呈欠螳
繝ｻUNION ALL繧帝勁縺阪∫ｬｬ荳蛻励〒繧ｽ繝ｼ繝医＆繧後ｋ縲
UNION
驥崎､辟｡縺
SELECT * FROM 陦ｨ1
UNION
SELECT * FROM 陦ｨ2
窶ｻ陦ｨ1 + 陦ｨ1
邨先棡縺ｯ繧ｽ繝ｼ繝縺輔ｌ繧縲
UNION ALL
驥崎､譛峨ｊ
SELECT * FROM 陦ｨ1
UNION ALL
SELECT * FROM 陦ｨ2
窶ｻ陦ｨ1 + 陦ｨ1
邨先棡縺ｯ繧ｽ繝ｼ繝縺輔ｌ縺ｪ縺縲
MINUS/EXCEPT
蟾ｮ蛻
SELECT * FROM 陦ｨ1
MINUS
SELECT * FROM 陦ｨ2
窶ｻ陦ｨ1 – 陦ｨ2
MINUS
SELECT * FROM 陦ｨ2
窶ｻ陦ｨ1 – 陦ｨ2
邨先棡縺ｯ繧ｽ繝ｼ繝縺輔ｌ繧縲
A陦ｨ
蛟､1
(NULL)
(NULL)
B陦ｨ
蛟､2
(NULL)
縺ｮ蝣ｴ蜷医、陦ｨ MINUS B陦ｨ縺ｮ隍蜷亥撫縺蜷医ｏ縺帷ｵ先棡縺ｯ縲
蛟､1
窶ｻ(NULL)縺ｯ霑斐＆繧後↑縺縲(NULL)縺ｯ1縺､縺ｮ蛟､縺ｨ縺励※謇ｱ繧上ｌ繧九
SELECT * FROM 陦ｨ1
EXCEPT
SELECT * FROM 陦ｨ2
EXCEPT
SELECT * FROM 陦ｨ2
INTERSECT
驥崎､縺励※縺繧九Ξ繧ｳ繝ｼ繝峨ｮ縺ｿ謚ｽ蜃ｺ
SELECT * FROM 陦ｨ1
INTERSECT
SELECT * FROM 陦ｨ1
邨先棡縺ｯ繧ｽ繝ｼ繝縺輔ｌ繧縲
Follow me!
