3 ms·
Postgres has row numbers: select *, row_number() over (order by id desc) as rownum from stuff; Window functions are really convenient. I'm not familiar en
by lobster_johnson 11y ago
Postgres has row numbers:
select *, row_number() over (order by id desc) as rownum
from stuff;
Window functions are really convenient. I'm not familiar enough with Oracle to say what the practical differences are, though.