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