mysql group by count case when
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 count(id) totalCnt,COUNT(case when warehouse_type=0 then null else 1 end) fixedCnt, COUNT(case WHEN warehouse_type=1 then 1 WHEN warehouse_type=2 then 1 when warehouse_type=0 and use_status=1 then 1 else null end) usedCnt from storage_warehouse where `status`=0 and delete_status=0;
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。