我有下面的脚本,我希望只按客户和类型进行分组,但是它迫使我也按p.ID分组,因为我在select语句中使用它。*如何应用这个乘法逻辑(5),并仅按客户和类型对所有p.ID和组进行汇总。
提前谢谢你的帮助!
SELECT
CUSTOMER
,TYPE
--,p.ID
,CASE
WHEN p.ID = 'GAX' THEN SUM(QTY) * 5
ELSE SUM(QTY)
END AS TOTAL_QTY
INTO TEMP_TABLE
FROM ORDERS o
INNER JOIN PRODUCT p ON o.MATERIAL_ID = p.MATERIAL_ID
GROUP BY CUSTOMER
,TYPE
--,p.ID;发布于 2020-06-25 11:31:49
我想你想要有条件的聚合。case是sum()的参数
SELECT CUSTOMER, TYPE,
SUM(CASE WHEN p.ID = 'GAX' THEN QTY * 5
ELSE QTY
END) AS TOTAL_QTY
INTO TEMP_TABLE
FROM ORDERS o INNER JOIN
PRODUCT p
ON o.MATERIAL_ID = p.MATERIAL_ID
GROUP BY CUSTOMER, TYPE;https://stackoverflow.com/questions/62574302
复制相似问题