表：Test

縱表轉橫表：

縱表效果圖：

1 select * from Test

實現的效果圖：

1 select Name2 ,sum(case Course when '語文' then Score else 0 end) as 語文3 ,sum(case Course when '數學' then Score else 0 end) as 數學4 ,sum(case Course when '英語' then Score else 0 end) as 英語 5 from Test group by Name6 go

橫表轉縱表：