ROWNUM

For each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of joined rows. The first row selected has a ROWNUM of 1, the second has 2, and so on.

You can use ROWNUM to limit the number of rows returned by a query, as in this example:

GIVES THE ROW NUMBER OF THE SELECT STATEMENT.

Example,

EXAMPLE 2

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/ROWNUM-Pseudocolumn.html

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top