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