display rows as page wise
Hello,
I have a requirement to display the limited records from the query which returns large number of records.
Assume that select * from orders order by order_id is giving me 1000 rows.
now i have to do a filter, display records from 25 to 50 or 50 to 150 etc...
i can pass the start range and number of records to be displayed as an input parameter to the query.
above example, start range is 25 and number of records should display is 25 from 25th record to next 25 records. (something like , select * from orders order by order id where rownum between 25 and 50)
again, start range is 50 and number of next records should display is 100 starting from 50th record to next 150 record.(something like , select * from orders order by order id where rownum between 50 and 150)
how can i achive this using a query. remember the start range and number of display count i can pass as an input to the query.
Appreciating the great help...
good day