select * from (
数据源
) a
pivot(
--统计列, 任意聚合函数
sum(colum)
for
--转换列
colum
in ('01','02','03','04','05','06','07','08','09','10','11','12')
);
select * from (
数据源
) a
pivot(
--统计列, 任意聚合函数
sum(colum)
for
--转换列
colum
in ('01','02','03','04','05','06','07','08','09','10','11','12')
);
转载于:https://my.oschina.net/wxh1989/blog/872370