UPDATE  scores as s 
SET ranking = sub.ranking
from (SELECT student_code
    ,subject_code
    ,RANK() OVER(PARTITION BY subject_code ORDER BY score DESC) as ranking from scores
    ) as sub
Where s.subject_code = sub.subject_code
AND s.student_code = sub.student_code;