首页 > 数据库技术 > 详细

mysql 不同条件count ,多条件count()

时间:2019-02-23 22:55:56      阅读:862      评论:0      收藏:0      [点我收藏+]

 create table abc(A int,B int) 

Select A,count(B) as total from ABC group by A
Select A,count(B) as total1 from ABC where B > 30 group by A
Select A,count(B) as totlal2 from ABC where B > 20 group by A

如何合并这三个查询?
得到一个查询结果:
A,total,total1,total2

答:

Select A,
count(B) as total,
sum(case when B > 30 then 1 else 0 end) as total1,
sum(case when B > 20 then 1 else 0 end) as total2 
from ABC group by A

 

自己的例子

 select  count(1)  from origin_crx_data  where create_time like ‘2019-02-23%‘ and source=‘12345‘

 select  count(1)  from origin_crx_data  where active_time like ‘2019-02-23%‘ and source=‘12345‘

合并为一条sql

SELECT
sum(case when create_time like ‘2019-02-23%‘ then 1 else 0 end) as inst_count,
sum(case when active_time like ‘2019-02-23%‘ then 1 else 0 end) as active_count
FROM  origin_crx_data   where source=‘12345‘

 

mysql 不同条件count ,多条件count()

原文:https://www.cnblogs.com/yuzhould/p/10424690.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!