Select and Return Top N Rows from Oracle Database

Location: Oracle Database :: SQL :: Select
From Select and Return Top N Rows from Oracle Database tutorial you will learn how to retrieve first N rows from ordered Oracle Database result set.

For example, you need to get the two rows with highest ID from numbers table.

SELECT * FROM numbers
 ORDER BY id DESC;

More details: Select and Return Top N Rows from Oracle Database.