SQL语句-表转置

 

 

 

SQL语句：

select Name,

sum(case when Subject='语文' then Result end)as '语文',

sum(case when Subject='数学' then Result end)as '数学',

sum(case when Subject='物理' then Result end)as '物理'

from Student

group by Name