【note】纵表转横表

最新推荐文章于 2022-02-11 09:12:02 发布

wu915064510

最新推荐文章于 2022-02-11 09:12:02 发布

阅读量234

点赞数

分类专栏： DB 文章标签： note DB MYSQL

本文链接：https://blog.csdn.net/wu915064510/article/details/39016921

版权

DB 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

select if null(c1, 'total'),
sum(if(c2 = 'B1', C3, 0)) as B1,
sum(if(c2 = 'B2', C3, 0)) as B2,
sum(if(c2 = 'B3', C3, 0)) as B3,
sum(if(c2 = 'B4', C3, 0)) as B4,
sum(C3) as TOTAL
from test_row_col
group by C1 with rollup;

For example

select STAT_DATE,
SUM(if(SERVICE_ID = '50001', CHARGE, 0)) as '50001',
SUM(if(SERVICE_ID = '50005', CHARGE, 0)) as '50005',
SUM(if(SERVICE_ID = '50006', CHARGE, 0)) as '50006',
SUM(if(SERVICE_ID = '53001', CHARGE, 0)) as '53001',
SUM(if(SERVICE_ID = '50014', CHARGE, 0)) as '50014',
SUM(CHARGE) as TOTAL
from `am_realtime_stat_detail`
where STAT_DATE BETWEEN '20140828' AND '20140901' and STAT_time = '235959'
group by STAT_DATE;