话不多说直接上代码 SELECT NAME ,math FROM student1 WHERE math IN (SELECT MAX(math) FROM student1 GROUP BY NAME); 结果展示