0 点赞 评论 收藏
分享
0 点赞 评论 收藏
分享
0 点赞 评论 收藏
分享
0 点赞 评论 收藏
分享

0 点赞 评论 收藏
分享

0 点赞 评论 收藏
分享

0 点赞 评论 收藏
分享
0 点赞 评论 收藏
分享
闷葫芦2019021...:看了一下你这结果不是出来了,只需要再加个排序就可以和你想要的结果一致
select `t1`.`user_name` AS `user_name`,'h_score' AS `维度`,sum((case when (`course` = '英语') then `h_score` else 0 end)) AS `英语`,
sum((case when (`course` = '俄语') then `h_score` else 0 end)) AS `俄语`,
sum((case when (`course` = '日语') then `t1`.`h_score` else 0 end)) AS `日语` from `t1` group by `user_name` union
select `user_name` AS `user_name`,'wscore' AS `维度`,sum((case when (`course` = '英语') then `w_score` else 0 end)) AS `英语`,sum((case when (`course` = '俄 语') then `w_score` else 0 end)) AS `俄语`,
sum((case when (`course` = '日语') then `w_score` else 0 end)) AS `日语` from `t1` group by `user_name` order by `user_name`;
😀😋
查看图片


0 点赞 评论 收藏
分享
0 点赞 评论 收藏
分享
0 点赞 评论 收藏
分享
创作者周榜
更多
关注他的用户也关注了: