SELECT total_scores as a
SET a.ranking = b.rank1
FROM(
SELECT student_code, RANK() OVER(ORDER BY total_score DESC) as rank1
FROM total_scores
) as b
WHERE a.student_code =b.student_code