sql大神来看看,技术实在是不好,一上午这个sql没写出来

Question

现在有这么一张表(https://img-ask.csdn.net/upload/201708/17/1502938958_357176.jpg)
如何用sql查询出这个效果(https://img-ask.csdn.net/upload/201708/17/1502938950_240666.jpg)

Answer 1

 SELECT
    stuName as 'name',
    max(case stuCode when 's1001' then stuId else 0 end) as '1月' ,
    max(case stuCode when 's1002' then stuId else 0 end) as '2月' ,
    max(case stuCode when 's1003' then stuId else 0 end) as '3月' ,
    max(case stuCode when 's1004' then stuId else 0 end) as '4月' ,
    max(case stuCode when 's1005' then stuId else 0 end) as '5月' ,
    max(case stuCode when 's1006' then stuId else 0 end) as '6月' ,
    max(case stuCode when 's1007' then stuId else 0 end) as '7月' ,
    max(case stuCode when 's1008' then stuId else 0 end) as '8月' ,
    max(case stuCode when 's1009' then stuId else 0 end) as '9月' ,
    max(case stuCode when 's1010' then stuId else 0 end) as '10月' ,
    max(case stuCode when 's1011' then stuId else 0 end) as '11月' ,
    max(case stuCode when 's1012' then stuId else 0 end) as '12月' 

from stuInfo  group   by stuNnme  order by stuNnme

这只是一个例子，具体的数据你就自己改就行了