代码:
select 学号,
sum(case when 课程='语文'then 成绩 else 0 end) as 语文,
sum(case when 课程='数学'then 成绩 else 0 end) as 数学,
sum(case when 课程='英语'then 成绩 else 0 end) as 英语
from 成绩表
group by 学号
代码:
select 学号,
sum(case when 课程='语文'then 成绩 else 0 end) as 语文,
sum(case when 课程='数学'then 成绩 else 0 end) as 数学,
sum(case when 课程='英语'then 成绩 else 0 end) as 英语
from 成绩表
group by 学号