为什么行专列后列名还要显示引号呢？很不理解，不加引号又是报错的？
可以试试下面这句： SELECT SALESORDERID, SALESMAN, "'苹果'" as 苹果, "'橘子'" as 橘子, "'草莓'" as 草莓 FROM SALES_ORDER PIVOT( SUM(AMOUNT) FOR PRODUCT_NAME IN('苹果','橘子','草莓')); 查询效果如下：
可以试试下面这句：
SELECT SALESORDERID,
SALESMAN,
"'苹果'" as 苹果,
"'橘子'" as 橘子,
"'草莓'" as 草莓
FROM SALES_ORDER
PIVOT( SUM(AMOUNT)
FOR PRODUCT_NAME IN('苹果','橘子','草莓'));
查询效果如下：