select * from cus where rownum between 2 and 6;

select * from
  (select t.*, rownum as rownum_ from t)
where rownum_ between 2 and 6

select t2.*, rownum from
  (select a, b, rownum as rownum_ from t) t2
where rownum_ between 2 and 6