sql 纵横表转换

SELECT * FROM dbo.TableA
SELECT Name FROM dbo.TableA group by Name

select Name,
sum(case Course when 'a' then Grade else 0 END) as 语文,
sum(case Course when 'b' then Grade else 0 end) as 数学,
sum(case Course when 'c' then Grade else 0 end) as 英语
from TableA
group by Name