原数据：

 目标数据：

实现代码：

SELECT YEAR AS "年",
SUM (DECODE (QUATER,1,RATE,0)) AS "季度一",2,0)) AS "季度二",3,0)) AS "季度三",4,0)) AS "季度四"
FROM SEASON
GROUP BY YEAR ORDER BY 1;

或者

SELECT * FROM (SELECT YEAR AS "年",QUATER,RATE FROM SEASON)PIVOT(SUM(RATE) FOR QUATER IN(1 AS "一季度",2 AS "二季度",3 AS "三季度",4 AS "四季度"));