sql row_number()用法

SELECT A.*,C.No AS StuNO,row_number() OVER(ORDER BY A.AllScore asc) AS RowID from 
(SELECT UCUID,FacePic,
--(LikeCount+AdminLikeCount)AS LikeCount,
--(CallCount+AdminCallCount)AS CallCount,ShareScore,Score,
(Score+ShareScore+(LikeCount+AdminLikeCount)+(CallCount+AdminCallCount)*10) AS AllScore 
FROM TV_UserDubbing)AS A
LEFT JOIN uc_User B ON A.UCUID=B.UID
LEFT JOIN uc_UserNo C ON C.UID=B.UID
ORDER BY A.AllScore DESC