17,090
社区成员
发帖
与我相关
我的任务
分享
select t.student_name,
t.xuehao,
max(decode(t.kecheng,'英语',t.chengji)) '英语',
max(decode(t.kecheng,'化学',t.chengji)) '化学',
max(decode(t.kecheng,'数学',t.chengji)) '数学',
max(decode(t.kecheng,'语文',t.chengji)) '语文'
from
(select s.student_name,s.xuehao,c.kecheng,g.chengji
from student s
left join grade g on s.xuehao=g.xuehao
left join course c on s.kecheng_id=c.id) t
group by student_name,xuehao