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

最新推荐文章于 2024-01-11 17:55:39 发布

「已注销」

最新推荐文章于 2024-01-11 17:55:39 发布

阅读量1.1k

点赞数 1

分类专栏： # ORACLE

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

版权

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

摘要由CSDN通过智能技术生成

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