MySQL Forums :: Database Design and Data Modelling :: How to design

Generally to do this you want to join the table to itself using the grouping field, and add to the join condition a value comparison, then select only rows not matching any greater values:

SELECT t1.*
FROM t1 LEFT JOIN t2 ON t1.group = t2.group AND t1.score < t2.score
WHERE t2.score IS NULL;