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