行转列sql题

样本数据

id name score 1 aa 30 2 aa 40 3 aa 50 1 bb 50 2 bb 40 3 bb 30

想转化成

name score1 score2 scoer3 aa 30 40 50 bb 50 40 30

---

方法一:

    select b.name,sum(b.score1) score1,sum(b.score2) score2,sum(b.score3) score3      from (          select a.name,          case when id=1 then score else 0 end score1,          case when id=2 then score else 0 end score2,          case when id=3 then score else 0 end score3          from abc a          ) b      group by b.name  

---

方法二:

select name,       sum(case when id=1 then score else 0 end) score1,      sum(case when id=2 then score else 0 end) score2,      sum(case when id=3 then score else 0 end) score3   from abc   group by name