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;