> For the complete documentation index, see [llms.txt](https://851958789.gitbook.io/notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://851958789.gitbook.io/notes/1112_highest_grade_for_each_student/slt.md).

# 思路1

选出每个学生的最大分数

```sql
SELECT student_id, course_id, MAX(grade)
FROM Enrollments
GROUP BY student_id;
```

再JOIN两表

```sql
SELECT e.student_id, MIN(e.course_id) as course_id, e.grade
FROM Enrollments e JOIN (
    SELECT student_id, course_id, MAX(grade) AS max_grade
    FROM Enrollments
    GROUP BY student_id
) AS t
ON e.student_id=t.student_id AND e.grade=t.max_grade
GROUP BY e.student_id
ORDER BY e.student_id;
```