SELECT HYDL_MC,TO_CHAR(JRK.RKXHRQ,'YYYY-MM')RQ,SUM(SJJE)SJJEFROM ECODE_ZS_JRK JRKGROUP BY TO_CHAR(JRK.RKXHRQ,'YYYY-MM'),HYDL_MCORDER BY TO_CHAR(JRK.RKXHRQ,'YYYY-MM')这是查询每个月的数据