[已解決]MS-SQL 合併不同列資料

ms sql sqlserver

seefood0329 2022-05-05 17:59:39 ‧ 678 瀏覽

分享至

HI 各位先進
若使用SQL Server，想詢問Budget的table如何下SQL指令才能變成右邊的表?

以下有新增table的SQL
https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=e4bbfa1af1ee2a965495af84c4789794

seefood0329 iT邦新手 5 級 ‧ 2022-05-05 18:10:35 檢舉

自己在其他地方找到解法了。SQL如下：
SELECT
PRODUCT_NO
,SUM(IIF(BUDGET_TYPE='Order',BUDGET_QTY,0)) AS 'B_OrderQties'
,SUM(IIF(BUDGET_TYPE='Order',BUDGET_TWD_AMOUNT,0)) AS 'B_OrderAmt'
,SUM(IIF(BUDGET_TYPE='Sales',BUDGET_QTY,0)) AS 'B_SalesQties'
,SUM(IIF(BUDGET_TYPE='Sales',BUDGET_TWD_AMOUNT,0)) AS 'B_SalesAmt'
FROM BUDGET
GROUP BY PRODUCT_NO