WITH TEST AS(
 SELECT '1' step, '홍길동' name, '아들' position, 'S' state  FROM DUAL UNION ALL
 SELECT '2' , '아버지', '양반', 'A'   FROM DUAL UNION ALL
 SELECT '2' , '형님', '아들', 'A'   FROM DUAL UNION ALL
 SELECT '2' , '누님', '딸', 'A'   FROM DUAL UNION ALL
 SELECT '2' , '어머니', '주부', 'S'   FROM DUAL UNION ALL
 SELECT '3' , '', '', ''   FROM DUAL
)
SELECT STEP,
             CASE WHEN CNT > 1 THEN NAME||'외'|| TO_CHAR(CNT - 1)||'명'
                      ELSE NAME
             END NAME,
             POSITION,
             STATE
FROM  (SELECT RANK() OVER (PARTITION BY STEP ORDER BY ROWNUM ) RK,
                         COUNT(1) OVER (PARTITION BY STEP) CNT,
                         STEP, NAME, POSITION, STATE
            FROM TEST) A
WHERE RK = 1

대충 이런 식이면 될듯..

댓글감사합니다..

훌륭하십니다.. ㅠㅠ

전 아직 RANK() OVER (PARTITION BY 을 활용법을 모르겠습니다... 흑흑