( 一 )行转列
原数据:
select '张三' as name,'语文' as subject,80 as score
union all
select '张三' as name,'数学' as subject,98 as score
union all
select '张三' as name,'英语' as subject,95 as score
union all
select '李四' as name,'语文' as subject,90 as score
union all
select '李四' as name,'数学' as subject,79 as score
union all
select '李四' as name,'英语' as subject,85