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