SQL求交集并集差集

2024-03-03 20:34:22

故事是这样的…..

故事情节: 表 tb_test 有两列, colA , colB; 求 colA , colB 的并交差集…

-- 计算并集

SELECT DISTINCT colB FROM tb_test

UNION

SELECT DISTINCT colA FROM tb_test

-- 计算交集

SELECT DISTINCT colB FROM tb_test

INTERSECT

SELECT DISTINCT colA FROM tb_test

-- 计算差集

SELECT DISTINCT colB FROM tb_test

EXCEPT

SELECT DISTINCT colA FROM tb_test

码农公寓