UPDATE total_scores as tsc
SET ranking = sub.ranking
FROM(
SELECT student_code, RANK() OVER(ORDER BY total_score DESC) as ranking
FROM total_scores
) as sub
WHERE tsc.student_code = sub.student_code ;