UPDATE total_scores as ts
SET ranking = sub.ranking
from (SELECT RANK() OVER(ORDER BY total_score DESC) as ranking, student_code
FROM total_scores ) as sub
where ts.student_code = sub.student_code