close
SQL SELECT IF 問題
請問各位SQL高手，若有以下問題，請問SQL語法是否有可能達成TAB-1轉成TAB-2的結果?TAB-2的表格結構事先create好。謝謝！TAB-1ID_欄位1_欄位2---------------------------001A10001B20002B10002C30002D40TAB-2ID_A_B_C_D-----------------------------0011020----002--103040
select C.id, sum(C.A) A, sum(C.B) B, sum(C.C) C, sum(C.D) D from ( select id, sum(f2) A, 0 B, 0 C, 0 D from test where id = '001' and f1 = 'A' group by id, f1 union select id, 0 A, sum(f2) B, 0 C, 0 D from test where id = '001' and f1 = 'B' group by id, f1 ) C group by C.id union select C.id, sum(C.A) A, sum(C.B) B, sum(C.C) C, sum(C.D) D from ( select id, 0 A, sum(f2) B, 0 C, 0 D from test where id = '002' and f1 = 'B' group by id, f1 union select id, 0 A, 0 B, sum(f2) C, 0 D from test where id = '002' and f1 = 'C' group by id, f1 union select id, 0 A, 0 B, 0 C, sum(f2) D from test where id = '002' and f1 = 'D' group by id, f1 ) C group by C.id 2012-08-09 09:13:48 補充： test -> TAB-1
用4次leftjoin就可以了
以上文章來自奇摩知識家，如有侵犯請留言告知
https://tw.answers.yahoo.com/question/index?qid=20120807000015KK10213