UPDATE total_scores
SET ranking = rk_scores.rk
FROM 
(SELECT student_code,
RANK() OVER(ORDER BY total_score DESC) AS rk
FROM total_scores) AS rk_scores
WHERE total_scores.student_code = rk_scores.student_code;