select max(XM0000) XM0000,max(ZYH000) ZYH000,max(CZYXM0) CZYXM0,max(RYBQMC) RYBQMC,max(RYCWH0) RYCWH0 ,max(RZKSMC) RZKSMC,min(CZRQ00) ZXRQ, max(CZRQ00) ZDRQ,sum(HJJE00) Amount from  VW_ZY_RQDt00  where ZYID00=2547174.00 and czrq00>='20200814' and czrq00<='20200824'


select ZYID00,ZYH000,GJBM00,GJBM01,XMBH00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FBBH00,YBZXLB,YBBRLB,SUM(XMSL00) XMSL00,SUM(HJJE00) HJJE00,SUM(ZFJE00) ZFJE00   from VW_ZY_RQDMX1_TS where  ZYID00=2547174.00 and QDRQ00>='20200814' and QDRQ00<='20200824' and FBBH00+0=3.00 and YBZXLB='1' and YBBRLB='0'  group by ZYID00,ZYH000,GJBM00,GJBM01,XMBH00,XMMC00,XMGG00,XMDW00,XMDJ00,ZFBL00,FBBH00,YBZXLB,YBBRLB  ORDER BY GJBM01