select substr(MODIFY_TIME,1,4) year,substr(MODIFY_TIME,6,2) month, if '$(月份)' is null then substr(MODIFY_TIME,6,2) day else substr(MODIFY_TIME,9,2) day end if, sum(STHYSHSL),sum(NSDYSHSL),sum(BSDYSHSL),sum(JGHYSHSL),sum(XSDYSHSL), from *** where substr(MODIFY_TIME,1,4) = '${年份}' ${if(len(月份) == 0,"","and substr(MODIFY_TIME,6,2) = '" + 月份 + "'")} group by substr(MODIFY_TIME,6,2),substr(MODIFY_TIME,1,4),substr(MODIFY_TIME,9,2) order by substr(MODIFY_TIME,1,4) 报错: |