UPDATE TOTAL_SCORES AS ST
SET RANKING = SUB.RANKING
FROM (
    SELECT STUDENT_CODE, RANK() OVER(ORDER BY TOTAL_SCORE DESC) AS RANKING
    FROM TOTAL_SCORES
) AS SUB
WHERE ST.STUDENT_CODE = SUB.STUDENT_CODE;