给定表
列转行的结果
解答SQL
select sid, '数学' as `subject`, `数学` as score from score2
union all
select sid, '语文' as `subject`, `语文` as score from score2
union all
select sid, '英语' as `subject`, `英语` as score from score2
给定表
列转行的结果
解答SQL
select sid, '数学' as `subject`, `数学` as score from score2
union all
select sid, '语文' as `subject`, `语文` as score from score2
union all
select sid, '英语' as `subject`, `英语` as score from score2