SQL · Functions and expressions

recursive cte

Walks a hierarchy such as a management chain or category tree.

sqlRunnable example sql course

Syntax

with recursive …

Example

Open in the lab

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

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.