UPDATE total_scores
SET ranking = A.ranking
FROM(
SELECT RANK() OVER(ORDER BY total_score DESC)AS ranking,total_score,student_code
FROM total_scores
)AS A
WHERE total_scores.student_code = A.student_code