window version

gistfile1.txt

SELECT name, subject, grade FROM 
  (SELECT student_id, subject_id, grade, RANK() OVER (PARTITION BY student_id ORDER BY grade) 
   FROM exams) 
 AS grades, students, subjects 
 WHERE grades.subject_id = subjects.subject_id AND grades.student_id = students.student_id 
 AND rank = 1 ORDER BY grade;