查找由n个连续数字组成的组是否在SQL中重复

WITH RECURSIVE Numbers AS (
  SELECT 1 AS Number
  UNION ALL
  SELECT Number + 1
  FROM Numbers
  WHERE Number < 100
)
SELECT *
FROM Numbers;

WITH RECURSIVE Numbers AS (
  SELECT 1 AS Number
  UNION ALL
  SELECT Number + 1
  FROM Numbers
  WHERE Number < 100
)
SELECT Number1, Number2, Number3
FROM (
  SELECT
    N1.Number AS Number1,
    N2.Number AS Number2,
    N3.Number AS Number3,
    COUNT(*) AS Count
  FROM Numbers N1
  JOIN Numbers N2 ON N2.Number = N1.Number + 1
  JOIN Numbers N3 ON N3.Number = N2.Number + 1
  GROUP BY Number1, Number2, Number3
  HAVING Count > 1
) AS DuplicateGroups;