怎么将RPT_DATE转为行,TOTAL转为列 。为什么这个转不了!截图是子查询的结果select MAX(CASE RPT_DATE WHEN '2023/9/6' THEN TOTAL ELSE 0 END) AS RPT_DATE from (SELECT RPT_DATE, SUM(FEED8_CSP_QTY + FEED8_CSP_AMT + FEED12_CSP_QTY + FEED12_CSP_AMT + FEED8_PILLAR_QTY + FEED8_PILLAR_AMT + FEED12_PILLAR_QTY + FEED12_PILLAR_AMT) AS TOTALFROM RPT_PC_OUTPUT_AGROUP BY RPT_DATE)