SELECTsum(glb.period_name,'JAN-04','A',0) 1月
sum(glb.period_name,'FEB-04','A',0) 2月
sum(glb.period_name,'MAR-04','A',0)3月.
.
.
sum(glb.period_name,'DEC-04','A',0) 12月
FROM TABLE
WHERE glb.period_name like '%04'
group by bbb
就是每次要将'JAN-04','FEB-04','MAR-04'...'DEC-04'该为'...-05'.如果可以不改这里的话,年度不同时,只需改WHERE glb.period_name like '%04'即可
非常感谢jaunt
|