在SQL中检测和合并日期范围连续重叠

SELECT t1.start_date, t2.end_date
FROM your_table t1
JOIN your_table t2 ON t1.end_date >= t2.start_date
WHERE t1.start_date <= t2.end_date

WITH recursive cte AS (
  SELECT start_date, end_date, ROW_NUMBER() OVER (ORDER BY start_date) AS rn
  FROM your_table
  WHERE start_date IS NOT NULL AND end_date IS NOT NULL
  UNION ALL
  SELECT c.start_date, t.end_date, c.rn
  FROM cte c
  JOIN your_table t ON c.end_date >= t.start_date AND c.rn = t.rn - 1
)
SELECT MIN(start_date) AS merged_start_date, MAX(end_date) AS merged_end_date
FROM cte
GROUP BY rn