helpme~ In oracle9i how to use rank over function

SQL statement :
select
deptno,
ename,
sal,
rank() over ( partition by deptno order by sal desc) as rank from emp
where deptno=20

result :
deptno|ename | sal |rank

20 | SCOTT | 3000 |1 
20 | FORD | 3000 |1 
20 | JONES | 2975 |3 
20 | ADAMS | 1100 |4 
20 | SMITH | 800 |5 

20 |SCOTT | 3000 |1 
20 |FORD | 3000 |1 
20 |JONES | 2975 |2 
20 |ADAMS | 1100 |3 
20 |SMITH | 800 |4 

thank for reading my question..^^ Received on Wed Mar 26 2003 - 20:22:42 CET