一行变多行查询 

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

 

posted @ 2017-03-27 17:41  pding  阅读(220)  评论(0)  编辑  收藏  举报