FETCH FIRST ROWS

FETCH FIRST ROWS ONLY

Introduced in Oracle 12c for pagination or top-N queries.

SELECT * FROM employees ORDER BY salary DESC FETCH FIRST 3 ROWS ONLY;

Can also use OFFSET for pagination:

SELECT * FROM employees ORDER BY employee_id OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY;