A simple solution is to wrap the query into a subselect with the ORDER statement first and applying the GROUP BY ...

First approach (LEFT JOIN) SELECT s.Name,c1.Id AS Max_Score_ID,c1.Score as Max_Score FROM Students s LEFT JOIN Scores c1 ON (c...

Table=check_group_by id group_by value ------------------------- 1 1 Value 1 2 1 Value 2 3 1 ...