select 姓名,sum(decode(科目,数学,分数,0)) 数学,
sum(decode(科目,语文,分数,0)) 语文,
sum(decode(科目,物理,分数,0)) 物理,
sum(decode(科目,化学,分数,0)) 化学,
sum(分数) 总分
from yourtable group by 姓名;
sum(decode(科目,语文,分数,0)) 语文,
sum(decode(科目,物理,分数,0)) 物理,
sum(decode(科目,化学,分数,0)) 化学,
sum(分数) 总分
from yourtable group by 姓名;
sum(decode(科目,语文,分数,'null')) 语文,
sum(decode(科目,物理,分数,'null')) 物理,
sum(decode(科目,化学,分数,'null')) 化学,
sum(分数) 总分
from yourtable group by 姓名;