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