select grade,row_number()over(partition by class order by grade desc) mm from 成绩表 where 班级=6 and mm=10
