sqlserver 汇总 行转列
select t.AccArea , (select accbal from v1 where accccy='MOP' and v1.accarea =t.accarea) as MOP ,
?(select accbal from v1 where accccy='HKD' and v1.accarea =t.accarea) as HKD ,
?(select accbal from v1 where accccy='OTHER' and v1.accarea =t.accarea) as OTHER
?? FROM [GBD_DW].[dbo].[F_ACCBAL] t
?? group by t.AccArea
?
?
?
select t.AccArea , max(t1.accbal) as MOP , max(t2.accbal) as HKD ,max(t3.accbal) as OTHER
?? FROM [GBD_DW].[dbo].[F_ACCBAL] t
?? left join (select * from v1 where accccy='MOP') t1 on t1.accarea = t.AccArea
?? left join (select * from v1? where accccy='HKD') t2 on t2.accarea = t.AccArea
?? left join (select * from v1? where accccy='OTHER') t3 on t3.accarea= t.AccArea
?? group by t.AccArea
