查询每班的最高分

查询每班的最高分

    select distinct student.id,student.username,student.score,student.classID,class.className   
    from student

    inner join class  
    on class.id = student.classID

   inner join (
   select max(score) as score ,classID from student group by classID
  )as maxScore on maxScore.score = student.score