学到一个高级用法 row_number()
select * ,row_number() over (partition by c_id order by s_score) from score;
https://www.jb51.net/article/254952.htm
学到一个高级用法 row_number()
select * ,row_number() over (partition by c_id order by s_score) from score;
https://www.jb51.net/article/254952.htm