create table tmp_table_row_transform_column SELECT name,fenshu,project FROM score 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哪一行信息就行了。