select * from (select rownum no,a.* from (select
generation_id,min(generation_date)as generation_date
from rpt_month_account_created
group by generation_id)a) where no>n and no<n+10
generation_id,min(generation_date)as generation_date
from rpt_month_account_created
group by generation_id)a) where no>n and no<n+10
(select
generation_id,min(generation_date)as generation_date
from rpt_month_account_created
group by generation_id
) where rownum <11