列转行--行转列问题(二)
sername,'语文' as subject,"语文" as score from ScoresStudent www.2cto.com
union
select username,'数学' as subject,"数学" as score from ScoresStudent
union
select username,'英语' as subject,"英语" as score from ScoresStudent
union
select username,'生物' as subject,"生物" as score from ScoresStudent;
作者 cupid1102