select s.sid '学号',s.sname '姓名',sum(case c.cid when '01' then sc.score end) as '语文',sum(case c.cid when '02' then sc.score end) as '数学',sum(case c.cid when '03' then sc.score end) as '外语'
from student s,sc ,course c
where s.sid=sc.sid and c.cid=sc.cid
group by s.sid,s.sname
学号,姓名,语文,英语,数学---作为标题显示查到的数据
最新推荐文章于 2021-03-16 01:27:07 发布