Oracle Limiting the rows returned by a query
Get first N rows with row limiting clause
The FETCH clause was introduced in Oracle 12c R1:
An example without FETCH that works also in earlier versions:
In this page (written and validated by A. Gawali) you learned about Oracle Limiting the rows returned by a query . What's Next? If you are interested in completing Oracle tutorial, your next topic will be learning about: Oracle Get row N through M from many rows before Oracle 12c.