UPDATE total_scores AS TS
SET ranking = SUB.ranking

FROM
    (
    SELECT
        student_code,
        RANK() OVER(ORDER BY total_score DESC) AS ranking
    FROM total_scores
    ) AS SUB
WHERE TS.student_code = SUB.student_code;