SELECT ZT_TYPE,SUM(NUM) NUM FROM scott.DJ_NSRXX WHERE ZT_TYPE in ('5','6')${if(len(date_s)==0,"","and DATA_DATE>='"+left(YEARDELTA(date_s,-1),7)+"'")}${if(len(date_e)==0,"","and DATA_DATE<='"+left(YEARDELTA(date_e,-1),7)+"'")}GROUP BY ZT_TYPE order by ZT_TYPE例如这样,我要判断date_date等于参数的日期减一年这个方法也试了,但是查出来没有数据...