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