17,140
社区成员




SELECT WK.HANDLINGSTAFF, COUNT(WK.SERIALNO) CNT from (select HANDLINGSTAFF, SERIALNO CNT from T_PBH_PROBLEMWORKITEMHIS) WK, T_PBH_PROBLEMPROCESSHIS PP
WHERE PP.ACCEPTTIME >= TO_DATE('2010-08-30', 'YYYY-MM-DD')
AND PP.ACCEPTTIME < TO_DATE('2010-08-30', 'YYYY-MM-DD') + 1
AND WK.SERIALNO = PP.SERIALNO
AND WK.HANDLINGROLE = '20090113165355'
AND WK.OPERATETYPE = '0005'
GROUP BY WK.HANDLINGSTAFF;