순서대로 나오고

나머지는 뒤에 나오는 걸 원하시면

랭킹 함수를 활용하면 됩니다.

with t as (
    select '01' cd, '코끼리' nm from dual
    union all select '02' cd, '사자' nm from dual
    union all select '03' cd, '호랑이' nm from dual
    union all select '04' cd, '토끼' nm from dual
    union all select '01' cd, '코끼리' nm from dual
    union all select '01' cd, '코끼리' nm from dual
    union all select '01' cd, '코끼리' nm from dual
    union all select '01' cd, '코끼리' nm from dual
    union all select '03' cd, '호랑이' nm from dual
    union all select '03' cd, '호랑이' nm from dual
    union all select '02' cd, '사자' nm from dual
    union all select '02' cd, '사자' nm from dual
    union all select '04' cd, '토끼' nm from dual
    union all select '04' cd, '토끼' nm from dual
)
select cd, nm
from (
    select cd, nm, rank() over(partition by cd order by rownum) rk
    from t 
) lst
order by rk, cd