数据库行列转换

select   name,
sum(case when course='java' then grade end) as java,
sum(case when course='C++' then grade end) as C++,
sum(case when course='C#' then grade end) as C#
from test group by name

转载：http://blog.csdn.net/u014768339/article/details/45912653