就比如说，有三个月的时间，我定一月份为开始时间，我选择二月份为截止时间，但是表格内的数据，没有变动，和开始时间为一月份，截止时间也是一月份显示的数据是一样的
SELECT '${nys}' nys ,'${nye}' nye ,cbdshi ,insu_admdvs ,jylx ,nld ,sum(jyrs) jyrs ,sum(jyrc) jyrc ,sum(zfy) zfy ,sum(zcnfy) zcnfy ,sum(jjzfze) jjzfze ,sum(jjzfze)/sum(zcnfy) zcnbxbl ,sum(jjzfze)/sum(zfy) sjbxbl ,sum(zfy)/sum(jyrs) rjylfy ,sum(jjzfze)/sum(jyrs) rjjjzf FROM dws_t_xsfx06 where 1=1 and rydl= '职工' ${if(len(nys)==0,""," and ny >= '" + nys + "')"} ${if(len(nye)==0,""," and ny <= '" + nye+ "')"} ${if(len(tcq) == 0,"","and cbdshi = '" + tcq + "'")} ${if(len(tcqx) == 0,"","and insu_admdvs = '" + tcqx + "'")} ${if(len(rydl) == 0,"","and rydl = '" + rydl + "'")} ${if(len(jylx) == 0,"","and jylx = '" + jylx + "'")} ${if(len(nld) == 0,"","and nld = '" + nld + "'")} group by cbdshi ,insu_admdvs ,jylx ,nld |
1min目标场景问卷
立即参与
