例子:
select * from
(select sum(nvl(x3,0)) x3,max(xxdm) xxdm,max(bh) bh from tjb2017.jcj511 where bh=1 group by xxdm)a,(select sum(nvl(x3,0)) x3,max(xxdm) xxdm,max(bh) bh from tjb2017.jcj511 where bh in (4,10,12,14) group by xxdm)b
where a.xxdm = b.xxdm and to_char(round( a.x3 ,2),'FM9999999999999999.00')!= to_char(round( b.x3 ,2),'FM9999999999999999.00')