select cptitle,dptitle,dblevel,jbtitle, sum(ZWGZ)as ZWGZ, sum(ZNGZ)as ZNGZ, sum(ZWJT)as ZWJT, sum(ZCGZ)as ZCGZ, sum(KHGZ)as KHGZ,sum(JBGZ)as JBGZ, sum(EWJBGZ)as EWJBGZ, sum(QQJ)as QQJ, sum(GDJT)as GDJT, sum(QTJT)as QTJT, sum(JJ)as JJ, sum(SJ)as SJ, sum(CDQQ)as CDQQ, sum(KK)as KK, sum(YFGZ)as YFGZ, sum(GJJ)as GJJ,sum(sb)AS SB from cvw_renliCostDetails where 1=1 and term1 between '${term1}' and '${term2}' AND cptitle = '${pgtitle}' ${if(len(dp) == 0,"","and dp in " +"(" +dp +")")} ${if(len(dblevel) == 0,"","and jbgrade in " +"(" +dblevel +")")} ${if(len(jbid) == 0,"","and jbid in " +"(" +jbid +")")} group by cptitle,dptitle,dblevel,jbtitle 如图这个是sql,除了公司以外其他全是多选的，那么我如何在select后编写来表达我选的那个参数集，其他的不展示。group by 后面同理 |
1min目标场景问卷
立即参与
