教你轻松掌握一个纵表转横表的"SQL"

fname       ftype             fvalue小乔        zaocan              10小乔       zhongcan             20小乔        wancan               5

fname       zaocan_value          zhongcan_value       wancan_value小乔           10                     20                    5

select Fname, sum(case Ftype when 'zaocan' then Fvalue else 0 end) as zaocan_value,sum(case Ftype when 'zhongcan' then Fvalue else 0 end) as zhongcan_value,sum(case Ftype when 'wancan' then Fvalue else 0 end) as wancan_value from case_table group by Fname