使用UNION实现mysql行列变化（二）

第二种方法：

select ('语文')subject , (select chinese from score) value from dual
union
select ('数学')subject , (select math from score) value from dual
union
select ('英语')subject , (select english from score) value from dual
union
select ('总分')subject , (select total from score) value from dual；