oracle 分析函数

create table FS_My_test
(
id     integer,
name   varchar2(20),
job    varchar2(10),
salary integer,
deptno integer
)
insert into FS_My_test values(1,'Jim',      'coder',    4000,100);
insert into FS_My_test values(2,'Lilei',    'singer',   6000,100);
insert into FS_My_test values(3,'Hanmeimei','model',    7000,200);
insert into FS_My_test values(4,'David',    'worker',   3000,300);
insert into FS_My_test values(5,'LinTao',   'worker',   5000,200);
insert into FS_My_test values(6,'Lucy',     'manager',  4500,100);
insert into FS_My_test values(7,'Lily',     'girl',     5500,300);
insert into FS_My_test values(8,'Susan',    'boy',      8000,300);
insert into FS_My_test values(9,'Miss',     'president',9000,200);


---salary
select 
t.id,
t.name,
t.job,
t.salary,
t.deptno,
row_number() over (order by salary desc) rr
 from  FS_My_test  t order by t.id;