row_number

1、row_number() over(order by 字段 asc)先对字段按照升序，再为每条记录返回一个序列号：

select empno,row_number() over(order by empno asc) rn from  emp;

2、row_number() over(partition by 字段1 order by 字段2 asc) 先按照字段1分组，再对分组后的数据进行以字段2升序排列

select job,sal,row_number() over(partition by job order by sal asc) rn from emp ;