Recursive CTEs
1 / 12
EasyOutput prediction

Generating a number sequence

What does this recursive CTE return?

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

← → arrow keys to navigate

Sign in to save your progress.