SELECT
C.ORG_SHORTNAME,
B.USER_NAME,
ROW_NUMBER () OVER ( PARTITION BY B.ORG_ID ORDER BY A.TOTAL_SCORE DESC ) CNO,
A.TOTAL_SCORE,
A.USER_ID
FROM
T_INDIVIDUAL_RANKING A
INNER JOIN T_USER B ON A.USER_ID = B.USER_ID
INNER JOIN SYS_ORG C ON C.ORG_ID = B.ORG_ID
10-25
6610
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
11-03
3247
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-11
4944
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
06-13
820
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)