${switch(lx,1,"and id in(--满意
SELECT a.letterid FROM
(SELECT UNITID,LETTERID FROM SLJ_NIBANUNIT where UNITID='"${dw}"') A
JOIN(SELECT distinct a.SLJID FROM SLJ_EVALUATE a,slj_info b WHERE a.sljid=b.id and a.SAT IN(2,3)
GROUP BY SLJID)B
ON A.LETTERID = B.SLJID
)",
2,"and id in (--不满意
SELECT A.letterid FROM
(SELECT UNITID,LETTERID FROM SLJ_NIBANUNIT where UNITID='"${dw}"') A
JOIN(SELECT distinct a.SLJID FROM SLJ_EVALUATE a,slj_info b WHERE
a.sljid=b.id and a.SAT=1
GROUP BY SLJID)B
ON A.LETTERID = B.SLJID
)",
）}
这个公式中lx无效
sql是： select loginname,substr(fromtime,0,10) rq,
substr(fromtime,10,2) h,--小时
linkinterval sc--通话时长
from slj_info
where 1=1
order by substr(fromtime,0,10) , loginname 结果集：109820如何写sql可以让同一工号同一天同一个小时的通话时长相加？求大神指点
