create table t(
name varchar2(20),
course varchar2(20),
result number
)
insert into t values('Scott','English',60);
insert into t values('Scott','語文',80);
insert into t values('Scott','數學',70);
insert into t values('司各特','語文',61);
insert into t values('司各特','English',71);
insert into t values('司各特','數學',81);
insert into t values('哥斯拉','English',82);
insert into t values('哥斯拉','語文',92);
insert into t values('哥斯拉','數學',00);
select name ,
sum(decode(course,'English',result,0)),
sum(decode(course,'語文',result,0)),
sum(decode(course,'數學',result,0))
from t
group by name
原谅我,我不会用PHP COEDE
|