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