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