求写出SQL查询oracle数据库学生表里的每个班级每个课程的总成绩

发布网友发布时间：2022-05-01 02:38

共1个回答

热心网友时间：2022-04-15 02:40

select course as '成绩总和',
sum(case when class = 'JSD1701' then score else 0 end) as 'jsd1701',
sum(case when class = 'JSD1702' then score else 0 end) as 'jsd1702',
sum(case when class = 'JSD1703' then score else 0 end) as 'jsd1703',
sum(case when class = 'JSD1704' then score else 0 end) as 'jsd1704'
from class_score_sum group by course;

追问大神呐！让我膜拜你！

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com