ORACLE取出连续区间

SELECT T.CAL_DAY,
       T.FLAG,
       ROWNUM AS RN,
       ROW_NUMBER() OVER(PARTITION BY T.FLAG ORDER BY T.CAL_DAY) AS SN,
       ROWNUM - ROW_NUMBER() OVER(PARTITION BY T.FLAG ORDER BY T.CAL_DAY) AS QJ
FROM TEST_GROUP T
ORDER BY T.CAL_DAY

SELECT MIN(T.CAL_DAY) AS BEG_DATE,
       MAX(T.CAL_DAY) AS END_DATE,
       T.FLAG,
       COUNT(1) AS "连续天数"
FROM (SELECT T.CAL_DAY,
             T.FLAG,
             ROWNUM AS RN,
             ROWNUM - ROW_NUMBER() OVER(PARTITION BY T.FLAG ORDER BY T.CAL_DAY) AS QJ
      FROM TEST_GROUP T) T
GROUP BY T.FLAG
         T.QJ
ORDER BY 1;

         本站文章除注明转载/出处外，均为本站原创，转载前请务必署名,转载请标明出处