ROW_NUMBER() OVER(PARTITION BY T.USER_NO ORDER BY T.BEGIN_DATE DESC) RN

Question

SELECT T.AREA_NO,
                             T.USER_NO,
                             T.BEGIN_DATE,
                             T.END_DATE,
                             ROW_NUMBER() OVER(PARTITION BY T.USER_NO ORDER BY T.BEGIN_DATE DESC) RN
                        FROM ODS.ODS_O_PROD_GSM_MON TROW_NUMBER() OVER(PARTITION BY T.USER_NO ORDER BY T.BEGIN_DATE DESC) RN
这个是什么意思，希望举例说明，谢谢

Answer 1

按USER_NO分组，同时按BEGIN_DATE 降序排序，给每组一个排序名次

Answer 2

建议楼主还是看看Oracle分析函数