摘要： 实现效果 初始查询结果 目标查询结果 语句 -- case when SELECT YEAR, MAX(CASE MONTH WHEN '1' THEN AMOUNT END ) AS "1", MAX(CASE MONTH WHEN '2' THEN AMOUNT END ) AS "2", MA 阅读全文