ROW_NUMBER() OVER( [ PRITITION BY col1] ORDER BY col2[ DESC ] )
ROW_NUMBER()
为返回的记录定义个行编号,PARTITION BY col1是根据col1分
组,ORDER BY col2[ DESC ]是根据col2进行排序。
SELECT ename,deptno ,sal,ROW_NUMBER()OVER(PARTITION BY deptno ORDER BY sal DESC) AS group_rank
FROM emp;