ORACLE_某列连续数判断

代码：

WITH t1 AS

 (SELECT 1 c1
    FROM dual
  UNION ALL
  SELECT 2 c1
    FROM dual
  UNION ALL
  SELECT 3 c1
    FROM dual
  UNION ALL
  SELECT 4 c1
    FROM dual
  UNION ALL
  SELECT 6 c1
    FROM dual)

SELECT c1 - rownum, COUNT(*) FROM t1 GROUP BY c1 - rownum

利用伪劣rownum，缺点如果数字间隔一致（如:2 4 6 8）会判断失误 - -