sql行转列

第一种传统方法：

SELECT SUM(  CASE item.PRODUCTCATEGORYNAME    WHEN '男西服'    THEN item.productcount    ELSE 0  END) AS singleclothes,  SUM(  CASE item.PRODUCTCATEGORYNAME    WHEN '男西裤'    THEN item.productcount    ELSE 0  END) AS singletrousersFROM PRODUCTION_SALES_ORDERITEM itemWHERE item.createdate BETWEEN TRUNC(sysdate-2) AND TRUNC(sysdate);

第二种sql函数：

SELECT *FROM  (SELECT item.PRODUCTCATEGORYNAME,    item.productcount  FROM PRODUCTION_SALES_ORDERITEM item  WHERE item.createdate BETWEEN TRUNC(sysdate         -2) AND TRUNC(sysdate)  ) pivot (SUM(productcount) FOR PRODUCTCATEGORYNAME IN ('男西服' AS singleclothes,'男西裤' AS singletrousers));