select
t.姓名,
sum(decode(科目,'语文',成绩,0)) AS "语文",
sum(decode(科目,'数学',成绩,0)) AS "数学",
sum(decode(科目,'英语',成绩,0)) AS "英语"
from 表 t
group by 姓名;
能提供一下表结构吗sql>desc 表名；
你的这个要给出表名吧，没有表名怎么写sql语句啊
