UPDATE total_scores AS ts
SET ranking = sub.ranking
FROM(
    SELECT student_code, RANK()OVER(ORDEB BY total_score DESC) AS ranking
    FROM total_scores
    )AS sub
    WHERE ts.student_code = sub.student_code