select * from ( 
select  A.ORDER0,a.GJBM00,a.XMMC00,a.XMGG00,a.XMDW00,to_char(a.XMDJ00) XMDJ00,
to_char(sum(a.XMSL00)) XMSL00,sum(a.HJJE00) HJJE00,sum(ZFJE00)ZFJE00,sum(JZJE00)JZJE00,sum(GFJE00)GFJE00,sum(YBZFJE)YBZFJE,a.FPXMMC,a.FPXMBH, a.ZFBL00 
 from VW_ZY_RQDMX8 A 
 Where A.ZYID00=565245
 and a.hjje00<>0
 and QDRQ00 >= '20190714' and QDRQ00 < '20190717'
 group  by  A.ORDER0,GJBM00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FPXMMC,FPXMBH  having sum(a.XMSL00)<>0
 order  by  GJBM00,ORDER0,FPXMBH
)