获取差集合的一种实现思路 

select * from (
  select * from (
    select '1' from dual
    union all
    select '2' from dual
    union all
    select '3' from dual
    union all
    select '4' from dual
    union all
    select '5' from dual
  )
  minus
  select * from (
    select '155' from dual
    union all
    select '255' from dual
    union all
    select '455' from dual
    union all
    select '555' from dual
  )
)

　　

posted @ 2014-07-29 15:02  行者无疆Duffy  阅读(175)  评论(0)  编辑  收藏  举报