아래와 같은 경우를 찾으시는 건지..

질문 내용으론 정확히 알기 어렵네요..

 

WITH TT AS

(

SELECT '1' GROUP_P,  1 SEQQ, 'AAA' TTDATA, '20120901' REGDATE, 'STAND' STAND FROM DUAL UNION ALL  --(기준)

SELECT '1' GROUP_P,  2 SEQQ, 'BBB' TTDATA, '20120901' REGDATE, '' STAND FROM DUAL UNION ALL

SELECT '1' GROUP_P,  3 SEQQ, 'CCC' TTDATA, '20120901' REGDATE, '' STAND FROM DUAL UNION ALL

SELECT '1' GROUP_P,  4 SEQQ, 'DDD' TTDATA, '20120901' REGDATE, '' STAND FROM DUAL UNION ALL

SELECT '2' GROUP_P,  1 SEQQ, 'AAA' TTDATA, '20120901' REGDATE, 'STAND' STAND  FROM DUAL UNION ALL

SELECT '2' GROUP_P,  2 SEQQ, 'BBB' TTDATA, '20120901' REGDATE, '' STAND  FROM DUAL UNION ALL

SELECT '2' GROUP_P,  3 SEQQ, 'CCC' TTDATA, '20120901' REGDATE, '' STAND  FROM DUAL UNION ALL

SELECT '2' GROUP_P,  4 SEQQ, 'AAA' TTDATA, '20120901' REGDATE, '' STAND  FROM DUAL UNION ALL

SELECT '2' GROUP_P,  1 SEQQ, 'AAA' TTDATA, '20120901' REGDATE, 'STAND'  STAND  FROM DUAL UNION ALL

SELECT '2' GROUP_P,  2 SEQQ, 'BBB' TTDATA, '20120901' REGDATE, '' STAND  FROM DUAL UNION ALL

SELECT '2' GROUP_P,  3 SEQQ, 'CCC' TTDATA, '20120901' REGDATE, '' STAND  FROM DUAL UNION ALL

SELECT '2' GROUP_P,  4 SEQQ, 'DDD' TTDATA, '20120901' REGDATE, '' STAND  FROM DUAL UNION ALL

SELECT '2' GROUP_P,  5 SEQQ, 'EEE' TTDATA, '20120901' REGDATE, '' STAND  FROM DUAL

)

SELECT T.*

FROM (

     -- 기준

     SELECT S.*

     FROM TT S

     WHERE S.GROUP_P = '1' 

     AND S.TTDATA    = 'AAA'

     AND S.STAND     = 'STAND'

     ) S

    ,(

     SELECT T.*

     FROM TT T

     WHERE T.STAND IS NULL  --> STAND IS NULL인 데이터 중에서

     ORDER BY T.GROUP_P     --> GROUP_P, SEQQ 순서로 

             ,T.SEQQ

     ) T

WHERE T.TTDATA = S.TTDATA   --> 기준의 TTDATA와 일치하는 

AND ROWNUM <= 1             --> 1건을 찾아라.

;