with temp_table as (select trunc(dbms_random.value(1,100)) b from dual connect by level < 5)
select temp_table.b, rownum from temp_table
order by temp_table.b
B ROWNUM
---------- ----------
58 2
60 4
70 1
99 3
Názor k článku
CTE a analytické funkce v PostgreSQL
