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