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;
  
SELECT * FROM total_scores
ORDER BY ranking ASC;