update total_scores
set ranking = sub.ranking
from (
    select student_code, RANK() OVER(ORDER BY total_score DESC) as ranking
    from total_scores
) as sub
where total_scores.student_code = sub.student_code;