select a, case when (rn=10 and nextRn is not null) or (rn>10) then 'Other'  else name end as nn from (
    select a, name, rownum rn,  lead(rownum,1) over (order by rownum)  as nextRn from (
             select 0.1 as a, 'a' as name from dual union all
             select 0.1 as a, 'b' as name from dual union all
             select 0.1 as a, 'c' as name from dual union all
             select 0.1 as a, 'd' as name from dual union all
             select 0.1 as a, 'e' as name from dual union all
             select 0.1 as a, 'f' as name from dual union all
             select 0.1 as a, 'g' as name from dual union all
             select 0.1 as a, 'h' as name from dual union all
             select 0.1 as a, 'q' as name from dual union all
              select 0.05 as a, 'o' as name from dual union all
             select 0.05 as a, 'p' as name from dual union all
             select 0.05 as a, 'z' as name from dual
  ) )