create table tmp_table_row_transform_column

SELECT name,fenshu,project

unpivot(gproject FOR fenshu in(chinese,math,english))AS up

select  name,project from(

  select name,max(fenshu) as repeat_fenshu,project

     from tmp_table_row_transform_column 

        group by name)a

行转列之后，group by 找到max哪一行信息就行了。