首页 > 代码库 > 获取差集合的一种实现思路

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

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  ))