Rownum between

select rin from (select rownum as rin
from floor_address where rownum <= 5)
where rin between 2 and 4