select count(extension_num) as callAll,sum(talk_length) as talkLength,
count(case when call_type=1 then 1 else null end) as callin,
count(case when call_type=0 then 1 else null end) as callout,
COUNT(case when call_type=0 and talk_length>0 then 1 else null end) as calloutYes,
COUNT(case when call_type=0 and talk_length=0 then 1 else null end) as calloutNo,
COUNT(case when call_type=1 and talk_length=0 then 1 else null end) as callinNo,
COUNT(case when call_type=1 and talk_length>0 then 1 else null end) as callInYes,
extension_num from t_call_call_record GROUP BY extension_num
select *,CONCAT((calloutYes/callout*100),'%') calloutPer,CONCAT((callinYes/callin*100),'%') callinper from (
select count(extension_num) as callAll,sum(talk_length) as talkLength,
count(case when call_type=1 then 1 else null end) as ca
select count(extension_num) as callAll,sum(talk_length) as talkLength,count(case when call_type=1 then 1 else null end) as callin,count(case when call_type=0 then 1 else null end) as callout,COUNT...
本文介绍了如何在MySQL中利用GROUP BY与COUNT函数结合CASE WHEN语句，对数据进行多条件的计数和分组统计。通过案例详细解释了这种查询方法在数据库操作中的应用，帮助读者理解并掌握复杂查询技巧。
最低0.47元/天 解锁文章
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
