SQLServer row_number() over (partition by order by) 

select * ,row_number() over (partition by c_id order by s_score) from score;

　　

posted @ 2022-07-12 13:43  极客船长  阅读(14)  评论(0)  编辑  收藏  举报