drop table abc; create table abc(id number,name varchar2(50),kcname varchar2(50),score number); insert into abc valu
drop table abc;   
create table abc(id number,name varchar2(50),kcname varchar2(50),score number); 
insert into abc values(1,'张三','语文',88); 
insert into abc values(2,'张三','数学',68); 
insert into abc values(3,'张三','英语',78);
insert into abc values(4,'李四','英语',78); 
insert into abc values(5,'李四','语文',88); 
insert into abc values(6,'李四','数学',79);
insert into abc values(7,'王五','英语',74); 
insert into abc values(8,'王五','语文',58); 
insert into abc values(9,'王五','数学',98);
select * from abc; 
select abc.name,sum(decode(kcname,'语文',score,null)) 语文, 
                sum(decode(kcname,'数学',score,null)) 数学, 
                sum(decode(kcname,'英语',score,null)) 英语 
                from abc group by abc.name;
结果:                 
name    语文  数学  英语 
1   王五  158 198 174 
2   李四  188 179 178 
3   张三  188 168 178
，