17,086
社区成员
发帖
与我相关
我的任务
分享大神们，帮帮忙，这个有点看不懂呀
select a.S# "学生编号" , a.Sname "学生姓名" ,
max(case c.Cname when N'语文' then b.score else null end) "[语文]",
max(case c.Cname when N'数学' then b.score else null end) "[数学]",
max(case c.Cname when N'英语' then b.score else null end) "[英语]",
cast(avg(b.score) as decimal(18,2)) "平均分"
from Student a
left join SC b on a.S# = b.S#
left join Course c on b.C# = c.C#
group by a.S# , a.Sname
order by "平均分" desc
max(case c.Cname when N'语文' then b.score else null end) "[语文]",
max(case c.Cname when N'数学' then b.score else null end) "[数学]",
max(case c.Cname when N'英语' then b.score else null end) "[英语]",
cast(avg(b.score) as decimal(18,2)) "平均分"
from Student a
left join SC b on a.S# = b.S#
left join Course c on b.C# = c.C#
group by a.S# , a.Sname
order by "平均分" desc
...全文
请发表友善的回复…
发表回复
qq_36781301 2018-04-29
- 打赏
- 举报
大神们帮忙解释一下这个
卖水果的net 2018-04-29
- 打赏
- 举报
楼主百度一下 行转列，应该就能理解了。
