在线等，用sql查询语句把一张表生成另外一张表

经典行转列，老生常谈了 select name ，max(case when kemu='yuwen' then score else 0 end) as yuwen , max(case when kemu='shuxue' then score esle 0 end) as shuxue , max(case when kemu='yingyu' then score esle