Oracle 18c

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

create table t as 
    select 1 as x from dual union all
    select 1 as x from dual;
2 rows affected

select distinct x
from t

X

1

select distinct x, row_number() over (order by x)
from t

X
ROW_NUMBER()OVER(ORDERBYX)

1
2

1
1