Oracle如何分组排序并产生序号

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_IND
posted @ 2019-09-23 20:04  xtjatswc  阅读(7841)  评论(0)  编辑  收藏  举报