MYSQL根据时间分组统计每小时的业务数据(24小时)

Mr Swan

于 2021-10-28 09:31:35 发布

阅读量953

点赞数

分类专栏： java 文章标签： mysql 数据库 dba

本文链接：https://blog.csdn.net/weixin_43830480/article/details/121007307

版权

根据日期分组,获取每天每小时的业务量

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

select
    create_time rq,
    SUM(case `hours` when 0 then sl else 0 end) as 'h0',
    SUM(case `hours` when 1 then sl else 0 end) as 'h1',
    SUM(case `hours` when 2 then sl else 0 end) as 'h2',
    SUM(case `hours` when 3 then sl else 0 end) as 'h3',
    SUM(case `hours` when 4 then sl else 0 end) as 'h4',
    SUM(case `hours` when 5 then sl else 0 end) as 'h5',
    SUM(case `hours` when 6 then sl else 0 end) as 'h6',
    SUM(case `hours` when 7 then sl else 0 end) as 'h7',
    SUM(case `hours` when 8 then sl else 0 end) as 'h8',
    SUM(case `hours` when 9 then sl else 0 end) as 'h9',
    SUM(case `hours` when 10 then sl else 0 end) as 'h10',
    SUM(case `hours` when 11 then sl else 0 end) as 'h11',
    SUM(case `hours` when 12 then sl e