Top-N

19c: scalable Top-N queries without further hints to the query planner

By Franck Pachot . The FETCH FIRST … ROWS ONLY syntax arrived in Oracle 12c and is much more convenient than using a subquery with ‘ORDER BY’ wrapped in a “WHERE ROWNUM < …” around it. But as I(…)