How to select rows in a given range?

How can I select rows from a table in a given range?

I can restrict maximum number of rows fetched using "rownum", like :

select * from tableA where rownum < 100;

But, as documented in Tech.net too, "rownum" doesn't work with "between" or
">" operators.

That's why, following queries DON'T work:

select * from tableA where rownum > 100 ; OR
select * from tableA where rownum BETWEEN 100 AND 150;

How can I realise this? I'd appreciate any ideas.

--
Thanks in advance

Emre AKBAG

akbag_at_scr.siemens.com
Siemens Corporate Research