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