1.行转列
(1)decode实现
SELECT t_year,
MAX(DECODE(t_month,‘1月’,t_value)) AS 一月,
MAX(DECODE(t_month,‘2月’,t_value)) AS 二月,
MAX(DECODE(t_month,‘3月’,t_value)) AS 三月,
MAX(DECODE(t_month,‘4月’,t_value)) AS 四月
FROM a_testtable WHERE t_month IN(‘1月’,‘2月’,‘3月’,‘4月’)
GROUP BY t_year;
(2)case when实现
SELECT t_year,
MAX(CASE t_month WHEN ‘1月’ THEN t_value END) AS 一月,
MAX(CASE t_mon