To preserve the order of the data.
example when row number is needed but there is no column were we can order by, then row_number() over (order by (select null)) can be done.