根据school_id 分组 取每组中score最大的 id
select SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY score desc),',',1) as id
from arrange
group by school_id
根据school_id 分组 取每组中score最大的 id
select SUBSTRING_INDEX(GROUP_CONCAT(id ORDER BY score desc),',',1) as id
from arrange
group by school_id