sql:
SELECT b.* FROM
(SELECT id,max(score) FROM student GROUP BY name) a
INNER JOIN student b ON a.id = b.id
SELECT b.* from student b where
b.id in (SELECT a.id FROM (SELECT id,max(score) FROM student GROUP BY name) a)
sql:
SELECT b.* FROM
(SELECT id,max(score) FROM student GROUP BY name) a
INNER JOIN student b ON a.id = b.id
SELECT b.* from student b where
b.id in (SELECT a.id FROM (SELECT id,max(score) FROM student GROUP BY name) a)