WITH cot_atrt_group_mpng AS
(
SELECT 1 menu_seq, 'AM100' atrt_id_group FROM dual
UNION ALL SELECT 1, 'AM200' FROM dual
UNION ALL SELECT 1, 'AM300' FROM dual
UNION ALL SELECT 1, 'AM400' FROM dual
UNION ALL SELECT 1, 'SUPER' FROM dual
UNION ALL SELECT 2, 'TM100' FROM dual
UNION ALL SELECT 2, 'TM200' FROM dual
UNION ALL SELECT 2, 'TM300' FROM dual
UNION ALL SELECT 2, 'SUPER' FROM dual
UNION ALL SELECT 2, 'HEAD'  FROM dual
UNION ALL SELECT 3, 'FC100' FROM dual
UNION ALL SELECT 3, 'FC200' FROM dual
UNION ALL SELECT 3, 'SUPER' FROM dual
UNION ALL SELECT 3, 'HEAD'  FROM dual
)
, cot_ao_info AS
(
SELECT 1 menu_seq, 'AMBlbd' menu_id, 'AM게시판' menu_nm FROM dual
UNION ALL SELECT 2, 'ActvMtlBasi', '리쿠르팅자료' FROM dual
UNION ALL SELECT 3, 'CantItro'   , '후보자도입'   FROM dual
)
SELECT DECODE(rn, 1, menu_id) menu_id
     , DECODE(rn, 1, menu_nm) menu_nm
     , atrt_id_group
  FROM (SELECT b.menu_id
             , b.menu_nm
             , a.atrt_id_group
             , ROW_NUMBER() OVER(PARTITION BY b.menu_id ORDER BY a.atrt_id_group) rn
          FROM cot_atrt_group_mpng a
             , cot_ao_info b
         WHERE a.menu_seq = b.menu_seq
        )
;