有时候需要做报表时，如何将一个字段年份划分成12个月份呢？

最新推荐文章于 2021-11-11 09:55:54 发布

幻梦星空

最新推荐文章于 2021-11-11 09:55:54 发布

阅读量737

点赞数

分类专栏： mysql eclipse jeecg

本文链接：https://blog.csdn.net/qq_25214695/article/details/51557487

版权

select v_short_name,
sum(case when c_time = '201501' then n_amount else 0 end) as Jan,
sum(case when c_time = '201502' then n_amount else 0 end) as Feb,
sum(case when c_time = '201503' then n_amount else 0 end) as Mar,
sum(case when c_time = '201504' then n_amount else 0 end) as Apr,
sum(case when c_time = '201505' then n_amount else 0 end) as May,
sum(case when c_time = '201506' then n_amount else 0 end) as Jun,
sum(case when c_time = '201507' then n_amount else 0 end) as Jul,
sum(case when c_time = '201508' then n_amount else 0 end) as Aug,
sum(case when c_time = '201509' then n_amount else 0 end) as Sep,
sum(case when c_time = '201510' then n_amount else 0 end) as Oct,
sum(case when c_time = '2