sql列转行问题！

[lubin1119]

有一个表：
no. id code value
1 100 abc 111
2 100 edf 222
3 100 ghi 333

怎样变成
id abc edf ghi
100 111 222 333

请大家帮助！

[gd4134]

看不明白。。。

[penglewen]

select id ,sum(case code when 'abc' then cast(value as int) end) as [abc],
sum(case code when 'edf' then cast( value as int) end) as [edf],
sum(case code when 'ghi' then cast (value as int) end) as [ghi]
from ctest
group by id