union实现的是并集,会消去重复行(A ∪ B)
1、运算对象的列数,数据类型相同
t_a表 t_b表
SELECT 6 AS id , 'Z' AS name SELECT id , name FROM t_b SELECT id , name FROM t_b
UNION UNION UNION ALL
SELECT id,name FROM t_a SELECT id,name FROM t_a SELECT id,name FROM t_a
INTERSECT 求交集(A ∩ B)
SELECT 1 AS id , 'y' AS name SELECT id , name FROM t_b
INTERSECT INTERSECT
SELECT id,name FROM t_a SELECT id,name FROM t_a
EXCEPT 减法运算(A-B=A- (A∩B))