update total_scores
   set ranking=( select RANK() OVER(ORDER BY total_score DESC) as RANK 
                   from total_scores t1
                   where t1.test_code=total_scores.test_code
                     and t1.student_code=total_scores.student_code
                )