WITH t AS
(
SELECT '20110415' ymd, 0 ilsu, '1054246' sabun FROM dual
UNION ALL SELECT '20110416', 0, '1054246' FROM dual
UNION ALL SELECT '20110417', 0, '1054246' FROM dual
UNION ALL SELECT '20110418', 1, '1054246' FROM dual
UNION ALL SELECT '20110419', 1, '1054246' FROM dual
UNION ALL SELECT '20110420', 1, '1054246' FROM dual
UNION ALL SELECT '20110421', 0, '1054246' FROM dual
UNION ALL SELECT '20110422', 1, '1054246' FROM dual
UNION ALL SELECT '20110423', 1, '1054246' FROM dual
UNION ALL SELECT '20110425', 1, '1054246' FROM dual
UNION ALL SELECT '20110426', 0, '1054246' FROM dual
UNION ALL SELECT '20110427', 0, '1054246' FROM dual
UNION ALL SELECT '20110428', 0, '1054246' FROM dual
UNION ALL SELECT '20110429', 1, '1054246' FROM dual
UNION ALL SELECT '20110415', 1, '1060442' FROM dual
UNION ALL SELECT '20110416', 0, '1060442' FROM dual
UNION ALL SELECT '20110417', 0, '1060442' FROM dual
UNION ALL SELECT '20110418', 1, '1060442' FROM dual
UNION ALL SELECT '20110419', 1, '1060442' FROM dual
UNION ALL SELECT '20110420', 1, '1060442' FROM dual
UNION ALL SELECT '20110421', 0, '1060442' FROM dual
UNION ALL SELECT '20110422', 1, '1060442' FROM dual
UNION ALL SELECT '20110423', 1, '1060442' FROM dual
UNION ALL SELECT '20110425', 1, '1060442' FROM dual
UNION ALL SELECT '20110426', 0, '1060442' FROM dual
UNION ALL SELECT '20110427', 0, '1060442' FROM dual
UNION ALL SELECT '20110428', 0, '1060442' FROM dual
UNION ALL SELECT '20110429', 1, '1060442' FROM dual
)
SELECT sabun
     , MIN(ymd) KEEP(DENSE_RANK LAST ORDER BY grp) s_ymd
     , MAX(ymd) KEEP(DENSE_RANK LAST ORDER BY grp) e_ymd
     , COUNT(*) KEEP(DENSE_RANK LAST ORDER BY grp) cnt
  FROM (
        SELECT sabun, ymd, ilsu
             , ROW_NUMBER() OVER(PARTITION BY sabun ORDER BY ymd)
             - ROW_NUMBER() OVER(PARTITION BY sabun, ilsu ORDER BY ymd)
            AS grp
          FROM t
        )
 WHERE ilsu = 0
 GROUP BY sabun
 ORDER BY sabun
;

감사합니다.

회사에서는 게시판에 글이 안써져서...

이제야 감사의 글을 올리네요.

아직 해보지는 않았지만, 잘 되겠지요...^^