不能在oracle sql开发中使用pivot函数

Question

这是我需要透视的表(年龄范围必须是一个属性和百分比作为其行)[1]: https://i.stack.imgur.com/TyQpV.jpg

已经编码:

SELECT SECOND_RESPONSE, 25-30, 30-35, 18-25, 45-50, 40-45, 35-40, 55-60 FROM
(SELECT SECOND_RESPONSE FROM SEC_ANALYSIS_AGE)
PIVOT
(
MAX(PERCENTAGE) FOR FIRST_RESPONSE IN (25-30, 30-35, 18-25, 45-50, 40-45, 35-40, 55-60)
) AS PIV;

ORA-00933: SQL命令未正确结束00933. 00000 - SQL命令未正确结束;*原因:
*行动:Line: 24 Column: 3

Answer 1

我建议使用includeFIRST_RESPONSE,PERCENTAGEcolumns select语句。应该是这个:

SELECT * FROM
(SELECT SECOND_RESPONSE, FIRST_RESPONSE, PERCENTAGE FROM SEC_ANALYSIS_AGE)
PIVOT
(
MAX(PERCENTAGE) FOR FIRST_RESPONSE IN ('25-30' as "25-30", '30-35' as "30-35", '18-25' as "18-25", '45-50' as "45-50", '40-45' as "40-45", '35-40' as "35-40", '55-60' as "55-60")
)

感谢