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