orcale 查询两个不同的条件的结果的差值(minus)

 select * from gongysb where id in (986771048, 1101771007,1101771002 )   minus   select * from gongysb where id in (986771048, 1101771007);--用途：insert gongysb  select * from gongysb where id in (986771048, 1101771007,1101771002 )   minus   select * from gongysb where id in (986771048, 1101771007)