Featured
-
No Featured Found!
Tags
Selecting the first n rows, Pagination, Rownum & ROW_NUMBER() in Oracle
There will be requirement where you might need to select the first n rows, or do pagination in Oracle. This can be achieved using Rownum.
Lets create sample table and data to understand the logic.
create table Employees (
id number ...