MYSQL组内排序

MYSQL 组内排序

group_concat + order by

SELECT id,substring_index(GROUP_CONCAT(id ORDER BY score desc),',',3) as num from test GROUP BY class