MINUS(差集)、INTERSECT(交集)和UNION (ALL)(并集)

「已注销」

于 2014-12-14 13:52:47 发布

阅读量1.3k

点赞数 1

分类专栏： # ORACLE

本文链接：https://blog.csdn.net/quixon/article/details/41923923

版权

本文介绍了SQL中的三种集合操作：MINUS用于获取两个集合的差集，INTERSECT用于获取交集，而UNION (ALL)则用于获取并集。在使用这些操作时，需要注意字段的明确性、类型和顺序的一致性，并且不能直接在集合运算中进行排序。示例代码和运行结果展示了这些操作的实际应用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MINUS(差集)

代码：

WITH A AS (
SELECT '1' AS num FROM dual UNION
SELECT '2' AS num FROM dual UNION
SELECT '3' AS num FROM dual UNION
SELECT '4' AS num FROM dual UNION
SELECT '5' AS num FROM dual UNION
SELECT '6' AS num FROM dual UNION
SELECT '7' AS num FROM dual UNION
SELECT '8' AS num FROM dual UNION
SELECT '9' AS num FROM dual ), B AS (
SELECT '6' AS num FROM dual UNION
SELECT '7' AS num FROM dual UNION
SELECT '8' AS num FROM dual UNION
SELECT '9' AS num FROM dual UNION
SELECT '10' AS num FROM dual UNION
SELECT '11' AS num FROM dual UNION
SELECT '12' AS num FROM dual UNION
SELECT '13' AS num FROM dual UNION
SELECT '14' AS num FROM dual UNION
SELECT '15' AS num FROM dual

最低0.47元/天解锁文章