SQL - Recursive CTE

Overview

Recursive CTEs reference themselves to traverse hierarchies or generate sequences.

WITH RECURSIVE nums(n) AS (
  SELECT 1
  UNION ALL
  SELECT n+1 FROM nums WHERE n < 5
)
SELECT * FROM nums;

WITH nums(n) AS (
  SELECT 1
  UNION ALL
  SELECT n+1 FROM nums WHERE n < 5
)
SELECT * FROM nums;

WITH RECURSIVE nums(n) AS (
  SELECT 1
  UNION ALL
  SELECT n+1 FROM nums WHERE n < 5
)
SELECT * FROM nums;