select 学号,
sum(case when 课程编号=1 then 成绩 else 0 end) as 课程编号1,
sum(case when 课程编号=2 then 成绩 else 0 end) as 课程编号2,
...........
from tablename group by 学号 order by 学号
如果课程多就用动态SQL语句,连接。
select 学号,
sum(case when 课程编号=1 then 成绩 else 0) as 课程编号1,
sum(case when 课程编号=2 then 成绩 else 0) as 课程编号2,
...........
from tablename group by 学号 order by 学号
如果课程多就用动态SQL语句,连接。