create table t (i int);
insert into t values (111);
insert into t values (222);
insert into t values (333);
insert into t values (111);
insert into t values (333);
insert into t values (222);
insert into t values (111);
select
dense_rank() over (order by i),
i
from t order by i;