Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE TEST_TABLE (
    ename varchar2(10),
    amount number
);
insert into TEST_TABLE (ename, amount)
select 'B', 22 from dual
union all select 'B', 22 from dual
union all select 'A', 11 from dual
union all select 'A', 11 from dual
union all select 'C', 33 from dual
union all select 'C', 44 from dual
union all select 'C', 55 from dual
union all select 'C', 55 from dual
union all select 'C', 55 from dual;


9 rows affected

with t as (
   SELECT 
      ename , 
      Amount ,
      min(amount) OVER (partition by ename) AS Min_amount
   FROM TEST_TABLE)
select ename, Amount,
   dense_RANK() OVER (ORDER BY Min_amount) AS RANK_ID
from t
order by ename, Amount;


ENAME
AMOUNT
RANK_ID


A
11
1

A
11
1

B
22
2

B
22
2

C
33
3

C
44
3

C
55
3

C
55
3

C
55
3