回音无痕(提问者)回复 zsh331 :
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
报缺少右括号，大神这啥情况？
周末活动活动脑子～
