合并句子

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

怎么写成一句

FineReport回音无痕 发布于 2018-5-21 18:33

关注问题

悬赏：2 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共9回答

最佳回答

flyingsnake发布于2018-5-21 18:33（编辑于 2023-9-6 09:34）

555

举报收起评论(5)

回音无痕(提问者) 不行，只有一行

2018-05-21 18:55

回音无痕(提问者) 回复回音无痕 :不对用都不能用

2018-05-21 18:57

回音无痕(提问者) select handleunit，count(1) jb,
sum( case when handlepj=2 then 1 else 0 end) my,
sum( case when and zzt=5 then 1 else 0 end) bj
from slj_info
where handleunit not in(0167,0004)
and createtime between \'${kssj} 00:00:00\' and \'${jssj} 23:59:59\'
group by handleunit试了下，报错缺失表达式，没看出啥问题，大神指点下

2018-05-21 19:07