第一步:建表
create table student_score(stuname varchar(10),course varchar(20),score decimal(5,1))
第二步:填充表
insert into student_scoreselect 'Steven','Operation System',88union select 'Steven','NetWork',79unionselect 'Nicole','Operation System',67unionselect 'Nicole','NetWork',53
第三步:sql实现
select stuname,
sum(case when course='NetWork' then score else 0 end) as NetWork,sum(case when course='Operation System' then score else 0 end) as 'Operation System' from student_score gr......
阅读全文