| select c.username,c.businessname ywlx,c.acceptname hj, count(*) bll from (select d.zllb businessname, b.name_ acceptname, (select t.staff_name from platform.bt_user t where t.username = b.assignee_) username, cast(b.start_time_ as date) dealtime from gisqbpm.act_hi_procinst a inner join gisqbpm.act_hi_taskinst b on a.proc_inst_id_ = b.proc_inst_id_ and b.assignee_ <> '-1' inner join bdcdj.slsq d on d.ywh = a.business_key_) c where c.dealtime between to_date('2016/1/1 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and to_date('2016/8/9 23:59:59', 'yyyy-mm-dd hh24:mi:ss') group by c.username, c.businessname, c.acceptname order by c.username |
