case when ... end + count 的用法

select 
count(case when from_unixtime(time/1000,'%Y-%m-%d') between '2018-01-01' and '2018-02-01' then 1 end) 一月份,
count(case when from_unixtime(time/1000,'%Y-%m-%d') between '2018-02-01' and '2018-03-01' then 1 end) 二月份,
count(case when from_unixtime(time/1000,'%Y-%m-%d') between '2018-03-01' and '2018-04-01' then 1 end) 三月份,
count(case when from_unixtime(time/1000,'%Y-%m-%d') between '2018-04-01' and '2018-05-01' then 1 end) 四月份,
count(case when from_unixtime(time/1000,'%Y-%m-%d') between '2018-05-01' and '2018-06-01' then 1 end) 五月份,
count(case when from_unixtime(time/1000,'%Y-%m-%d') between '2018-06-01' and '2018-07-01' then 1 end) 六月份,
count(case when from_unixtime(time/1000,'%Y-%m-%d') between '2018-07-01' and '2018-08-01' then 1 end) 七月份,
count(case when from_unixtime(time/1000,'%Y-%m-%d') between '2018-08-01' and '2018-09-01' then 1 end) 八月份
from table_name;
©著作权归作者所有,转载或内容合作请联系作者
平台声明：文章内容（如有图片或视频亦包括在内）由作者上传并发布，文章内容仅代表作者本人观点，简书系信息发布平台，仅提供信息存储服务。

推荐阅读更多精彩内容