假设你这个源表的表名为bd(表名随便起的),字段:学生姓名为xm,课程名称为kc,考试成绩为cj。1 :select xm 学生姓名,
sum(decode(kc, '数学', cj, 0)) 数学成绩,
sum(decode(kc, '英语', cj, 0)) 英语成绩from bd where xm in (select b.xm
from (select xm, cj from bd where kc = '数学') b,
(select xm, cj from bd where kc = '英语') c ... |