27,580
社区成员
发帖
与我相关
我的任务
分享
select m.MName 姓名,
max(case n.FName when '语文' then p.Score else 0 end) [语文],
max(case n.FName when '数学' then p.Score else 0 end) [数学],
max(case n.FName when '英语' then p.Score else 0 end) [英语],
max(case n.FName when '历史' then p.Score else 0 end) [历史]
from Member m , 课程表 n , Score p
where m.MID = p.MID and p.FID = n.FID
group by m.MName
select a.NName,
max(case when b.fname='语文' then c.Score else 0 end) as 语文,
max(case when b.fname='数学' then c.Score else 0 end) as 数学,
max(case when b.fname='英语' then c.Score else 0 end) as 英语,
max(case when b.fname='历史' then c.Score else 0 end) as 历史
from
member a,课程表 b,score c
where
a.mid=c.mid and b.fid=c.fid
group by
a.nname