SQL - Recursive Query

About

A recursive query is a query that is recursive.

Example

Calcite

WITH RECURSIVE aux(i) AS (
  VALUES (1)
  UNION ALL
  SELECT i+1 FROM aux WHERE i < 10
)
SELECT * FROM aux
1, 2, 3, 4, 5, 6, 7, 8, 9

Powered by ComboStrap