SQL多条件统计查询

最新推荐文章于 2024-06-30 07:27:16 发布

weixin影子

最新推荐文章于 2024-06-30 07:27:16 发布

阅读量2.7k

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/weixin_41120504/article/details/82464404

版权

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

摘要由CSDN通过智能技术生成

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_

最低0.47元/天解锁文章

weixin影子

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
SQL多条件统计查询

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_f...
复制链接

扫一扫

专栏目录