sql 行转列 求教 字段名的转换

我现在 想按照 字段bid 执行行转列把他转成第二个图片的那样
Mybatis怎么整。。。

建一个resultMap

可以利用sum(if())查出各科成绩（我就假设表名是s好了）
select uid, uname, sum(if(cname='语文', score, 0)) as chinese, sum(if(cname='数学', score, 0)) as maths, sum(if(cname='英语', score, 0)) as english, sum(if(cname='政治', score, 0)) as politics
from s
group by uid

select uid, uname, sum(if(cname='语文', score, 0)) as chinese, sum(if(cname='数学', score, 0)) as maths, sum(if(cname='英语', score, 0)) as english, sum(if(cname='政治', score, 0)) as politics
from s
group by uid

小伙子，老夫这里有一本秘籍
http://blog.csdn.net/mango_love/article/details/51210020

http://blog.csdn.net/mango_love/article/details/51210020