WITH t AS
(
SELECT 11111 id, '20141123' dt, 0 cnt FROM dual
UNION ALL SELECT 11111, '20141124', 2 FROM dual
UNION ALL SELECT 11111, '20141125', 3 FROM dual
UNION ALL SELECT 11111, '20141126', 6 FROM dual
UNION ALL SELECT 11111, '20141127', 2 FROM dual
UNION ALL SELECT 11111, '20141128', 0 FROM dual
UNION ALL SELECT 11111, '20141129', 1 FROM dual
UNION ALL SELECT 11111, '20141130', 0 FROM dual
UNION ALL SELECT 11111, '20141201', 1 FROM dual
UNION ALL SELECT 11111, '20141202', 2 FROM dual
UNION ALL SELECT 11111, '20141203', 0 FROM dual
UNION ALL SELECT 11111, '20141204', 1 FROM dual
UNION ALL SELECT 11111, '20141205', 2 FROM dual
)
SELECT *
  FROM (SELECT id
             , MIN(dt) sdt
             , MAX(dt) edt
             , COUNT(*) cnt
             , RANK() OVER(ORDER BY COUNT(*) DESC) rk
          FROM (SELECT id, dt
                     , TO_DATE(dt, 'yyyymmdd')
                     - ROW_NUMBER() OVER(PARTITION BY id ORDER BY dt) gb
                  FROM t
                 WHERE cnt > 0
                )
         GROUP BY id, gb
        )
 WHERE rk = 1
;

마농님~

정말 감사합니다.

정확히 제가 원하는 결과 입니다.

다시 한번 감사 드립니다.