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