
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 ... 
                       
        
        
