Ask for between row selection

[Raminder]

You will have to use 'top n' query. Syntax can be found in Oracle documentation.
A crude method is to use the ROWNUM pseudocolumn. Eg Select * from your_table where rownum between 25 and 50;