select * from (
select name,fraction,course from t_temp
)
pivot
(
sum(fraction)
for course in ('语文','数学','英语')
)
select name,fraction,course from t_temp
)
pivot
(
sum(fraction)
for course in ('语文','数学','英语')
)
order by name
但是 in的值 不能是 动态的。