WITH tt AS
(
SELECT 1 num, '파' nm FROM dual
UNION ALL SELECT 2, '마' FROM dual
UNION ALL SELECT 1, '카' FROM dual
UNION ALL SELECT 3, '바' FROM dual
UNION ALL SELECT 2, '다' FROM dual
UNION ALL SELECT 2, '사' FROM dual
UNION ALL SELECT 2, '아' FROM dual
UNION ALL SELECT 1, '가' FROM dual
UNION ALL SELECT 1, '자' FROM dual
UNION ALL SELECT 1, '차' FROM dual
UNION ALL SELECT 2, '라' FROM dual
UNION ALL SELECT 1, '나' FROM dual
UNION ALL SELECT 3, '타' FROM dual
UNION ALL SELECT 2, '하' FROM dual
)
SELECT num, nm
     , ROW_NUMBER() OVER(PARTITION BY num, rn1-rn2 ORDER BY nm) rn
     , COUNT(*) OVER(PARTITION BY num, rn1-rn2) rowspan
  FROM (SELECT num, nm
             , ROW_NUMBER() OVER(ORDER BY nm) rn1
             , ROW_NUMBER() OVER(PARTITION BY num ORDER BY nm) rn2
          FROM tt
        )
 WHERE CEIL(rn1/10) = 1
   AND ROWNUM <= 10
 ORDER BY nm
;

감사합니다. ( _o_ )