ROWNUM vs ROW_NUMBER() and Oracle 12c fetch first

Prior to Oracle 12c, there were two ways to do ‘top-n’ queries: use rownum after sorting rows with “order by” use row_number() over (order by) Top-n queries are usually required… Read more »