SQL & PL/SQL

Hi,

I have a problem using rownum>x and rownum between two numbers, however rownum<x is OK.

This is the case:

If I do the following SELEC:
select distinct attributename from ddd_model_attribute_names order by 1;

It returns 28 rows.

If I do this:
select distinct attributename from ddd_model_attribute_names where rownum<8 order by 1;

It returns 7 rows.

If I do:
select distinct attributename from ddd_model_attribute_names where rownum<25 order by 1;

It returns 24 rows

If I do:
select distinct attributename from ddd_model_attribute_names where rownum<40 order by 1;

It returns 28 rows


However, if I try to have rownum>21 it doesn't find anything, also if I have rownum between 7 and 14, it doesn't return any rows. Why is that? What can I do to solve this issue?

Thank you.
Regards,
Anne