http://blog.csdn.net/quixon

  博客园 :: 首页 :: 新随笔 :: 联系 :: 订阅 :: 管理 ::

随笔分类 -  ORACLE

MINUS(差集)、INTERSECT(交集)和UNION (ALL)(并集)
摘要：MINUS(差集)代码：WITH A AS (SELECT '1' AS num FROM dual UNIONSELECT '2' AS num FROM dual UNIONSELECT '3' AS num FROM dual UNIONSELECT '4' AS num FROM dual ... 阅读全文
posted @ 2014-12-14 13:52 veygoux 阅读(626) 评论(0) 推荐(0)