select loginname,substr(lettertype,0,4) value,count(1) from slj_info where lettertype is not null and createtime between '${kssj} 00:00:00' and '${jssj} 23:59:59' and loginname in (select loginname from ${SWITCH(gh,'1','dh','2','wl','3','jb','4','db')} order by loginname) group by loginname,substr(lettertype,0,4) order by loginname 执行时报缺失右括号,什么鬼? |