序号函数

序列函数：
row_number()
显示分区中不重复不间断的序号
dense_rank()
显示分区中重复不间断的序号
rank()
显示分区中重复间断的序号
– 查询各部门员工基本工资排名
select *,
row_number() over (partition by deptno order by sal desc ) as 工资排名1,
dense_rank() over (partition by deptno order by sal desc ) as 工资排名2,
rank() over (partition by deptno order by sal desc )