MySQL数据库中没有此方法?
SELECT *,ROW_NUMBER() OVER(PARTITION BY s_id,c_id ORDER BY s_score DESC) FROM score;
score
Sqlsever 才有