行转列语句，记录一下

select * from

(select UserName,Subject,Source from TestTable) testpivot(sum(Source) for Subject in(语文,数学,英语)

) pvt