Oracle pivot错误

Question

您好，我在oracle中使用了以下查询来获取数据。它在sql server中工作得很好，但是，当我试图在oracle中执行它时，它给出了错误。

    SELECT PRODUCT, FRED, KATE FROM (
    SELECT CUST, PRODUCT, QTY
    FROM Product
    )
    PIVOT
    (
    SUM(QTY) FOR CUST IN (FRED, KATE)
    )
    ORDER BY Product

错误：

​

表o/p如下

​

​

谢谢

Answer 1

试试SUM(QTY) FOR CUST IN ('FRED' as fred , 'KATE' as kate)