一行变多行查询

select A.id,A.Chinese as 各科成绩 from Score A
union all
select A.id,A.Math as 各科成绩 from Score A

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/Med1tator/p/6627885.html