SELECT @rownum:=@rownum+1 'rank', Grades.Student, Grades.GenAve FROM Grades, (SELECT @rownum:=0) r ORDER BY GenAve DESC