------------------
However, I must ask - why in the world do you want to do this at all? It is a very odd request.
-------------------

I use it quite regularly where the client requires the data to be seperated in 4-5 sets and then apply different rules on each set.

You can do it as

select *
from ( select a.*, rownum rnum
from ( YOUR_QUERY_GOES_HERE -- including the order by ) a
where rownum <= MAX_ROWS )
where rnum >= MIN_ROWS