select count(1),
HANDLEUNIT
from slj_info
where
handleunit not in(0167,0004)
and createtime between '${kssj} 00:00:00' and '${jssj} 23:59:59'
group by handleunit
select
handleunit,count(*)
from slj_info
where handleunit not in(0167,0004)
and HANDLEPJ=2
and createtime between '${kssj} 00:00:00' and '${jssj} 23:59:59'
group by handleunit
select
handleunit,count(*)
from slj_info
where handleunit not in(0167,0004)
and zzt=5
and createtime between '${kssj} 00:00:00' and '${jssj} 23:59:59'
group by handleunit
怎么写成一句