create table t (n1 integer);

insert into t values (1);
insert into t values (2);
insert into t values (2);
insert into t values (3);

select n1,
       rank() over (partition by n1 order by n1) r,
       dense_rank() over (partition by n1 order by n1) dr,
       percent_rank() over (partition by n1 order by n1) pr,
       cume_dist() over (partition by n1 order by n1) cd,
       ntile(3) over (partition by n1 order by n1) nt
  from t
  order by n1;

1   1   1   0   1   1
2   1   1   0   1   1
2   1   1   0   1   2
3   1   1   0   1   1

           1                     1                     1       0.000000000000000      0.2500000000000000                     1
           2                     1                     1       0.000000000000000      0.5000000000000000                     1
           2                     1                     1       0.000000000000000      0.5000000000000000                     1
           3                     1                     1       0.000000000000000      0.2500000000000000                     1