select name 姓名, max(decode(kemuid, 'km1', score, 0)) 语文, max(decode(kemuid, 'km2', score, 0)) 数学, max(decode(kemuid, 'km3', score, 0)) 英语 from tb_fenshu group by name
SELECT T.name '姓名', T1.score '语文', T2.score '数学', T3.score '英语' FROM (SELECT T1.empid,T1.score FROM tb_fenshu WHERE kemuid='km1') T1, (SELECT T2.empid,T2.score FROM tb_fenshu WHERE kemuid='km2') T2, (SELECT T3.empid,T3.score FROM tb_fenshu WHERE kemuid='km3') T3, SELECT T.name,T.empid FROM 学生表 T WHERE T.empid=T1.empid AND T.empid=T2.empid AND T.empid=T3.empid
max(decode(kemuid, 'km1', score, 0)) 语文,
max(decode(kemuid, 'km2', score, 0)) 数学,
max(decode(kemuid, 'km3', score, 0)) 英语
from tb_fenshu
group by name
(SELECT T1.empid,T1.score FROM tb_fenshu WHERE kemuid='km1') T1,
(SELECT T2.empid,T2.score FROM tb_fenshu WHERE kemuid='km2') T2,
(SELECT T3.empid,T3.score FROM tb_fenshu WHERE kemuid='km3') T3,
SELECT T.name,T.empid FROM 学生表 T
WHERE T.empid=T1.empid
AND T.empid=T2.empid
AND T.empid=T3.empid