[b]fname[/b] [b]ftype[/b] [b]fvalue[/b]
小乔 zaocan 10
小乔 zhongcan 20
小乔 wancan 5
转换后的表结构:
[b]fname[/b] [b]zaocan_value[/b] [b]zhongcan_value [/b] [b]wancan_value[/b]
小乔 10 20 5
纵表转横表SQL示例:
资料引用:http://www.knowsky.com/395671.html
小乔 zaocan 10
小乔 zhongcan 20
小乔 wancan 5
转换后的表结构:
[b]fname[/b] [b]zaocan_value[/b] [b]zhongcan_value [/b] [b]wancan_value[/b]
小乔 10 20 5
纵表转横表SQL示例:
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
资料引用:http://www.knowsky.com/395671.html