create table rank_test (id number(3),salary number)

insert into rank_test values (1,100)
insert into rank_test values (1,200)
insert into rank_test values (1,150)
insert into rank_test values (1,100)

insert into rank_test values (2,100)
insert into rank_test values (2,150)

insert into rank_test values (3,250)

SQL> select * from rank_test
2 /

ID SALARY
---------- ----------
1 100
1 200
1 150
1 100
2 100
2 150
3 250

7 rows selected.


1 select ID,SALARY ,
2 RANK() over (partition by ID order by SALARY desc) "RANK"
3 FROM rank_test
4 /

ID SALARY RANK
---------- ---------- ----------
1 200 1
1 150 2
1 100 3
1 100 3
2 150 1
2 100 2
3 250 1



SQL> select ID,SALARY ,
2 RANK(100) within group (order by SALARY) "RANK"
3 FROM rank_test
4 /
RANK(100) within group (order by SALARY) "RANK"
*
ERROR at line 2:
ORA-00907: missing right parenthesis


В чем проблема ??

Oracle8i Enterprise Edition Release 8.1.6.3.0

RANK

Aggregate Syntax

rank_aggregate::=
RANK ( expr) WITHIN GROUP( ORDER BY expr DESC | ASC ,|NULLS |FIRST |LAST)

Analytic Syntax
rank_analytic::= RANK ( ) OVER ( query_partition_clause order_by_clause )





Это из Oracle9 i SQL Reference

6-120

может первый вариант толко для 9i