«

mysql group by count case when

时间:2024-2-19 17:27     作者:韩俊     分类: Mysql


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;

标签: mysql

热门推荐