教你轻松掌握一个纵表转横表的"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