Sunday, April 27, 2014

Oracle - difference or changes between two rows from two tables

 


In the above figure we read the "/" as "not in" and the "∪" as "union".   In sum, we want the table comparison SQL to find:
 
select *
from 
(
( select * from employee1
  minus 
  select * from employee2)
union all
( select * from employee2
  minus
  select * from employee1)
)

No comments:

Post a Comment