SQL多条件统计查询

weixin影子

于 2018-09-07 15:23:33 发布

阅读量2.8k

点赞数

分类专栏： SQL

本文链接：https://blog.youkuaiyun.com/weixin_41120504/article/details/82464404

版权

本文介绍了如何使用SQL进行多条件统计查询，包括利用WHERE子句设置复杂条件，结合GROUP BY和HAVING子句进行数据分组过滤，以及运用聚合函数如COUNT(), SUM()等进行统计分析。通过实例解析，帮助读者掌握高级SQL查询技巧。" 130682692,11130912,SpringBoot源码分析：SpringApplication的启动流程,"['java', 'Springboot', '源码分析']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT  date_format(from_unixtime(created_at),'%Y%m%d')as 'time' ,count(1) as 'num',
(select count(1) from tre_upgrade_log where new_grade=1 and date_format(from_unixtime(created_at),'%Y%m%d')=date_format(from_unixtime(t.created_at),'%Y%m%d'))as 'grade_01',
(select count(1) from tre_upgrade_log where new_grade=2 and date_format(from_unixtime(created_at),'%Y%m%d')=date_format(from_unixtime(t.created_at),'%Y%m%d'))as 'grade_02',
(select count(1) from tre_upgrade_log where new_grade=3 and date_format(from_unixtime(created_at),'%Y%m%d')=date_format(from_unixtime(t.created_at),'%Y%m%d'))as 'grade_03',
(select count(1) from tre_upgrade_log where new_grade=4 and date_format(from_unixtime(created_at),'%Y%m%d')=date_format(from_unixtime(t.created_at),'%Y%m%d'))as 'grade_04',
(select count(1) from tre_upgrade_log where new_