Using SQL row limiting clause

In this post we will see how to limit or omit a set of rows in Oracle using the offset and fetch clauses. In versions prior to Oracle 12c, much use was made of the ROWNUM clause, however, when using it with the ORDER BY clause, the developer might not have the expected return. These new clauses are available from Oracle 12c. We will use as an example, the EMPLOYEES table of schema HR - which in our example will have only 10 records and some columns. Table HR.Employees Offset