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

第二种方法：

?

1 2 3 4 5 6 7

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；