Recursive CTE for Number Sequence

Hard
ctes Databricks Google Snowflake

Write a recursive CTE to generate a sequence of numbers from 1 to 10. Return a single column n.

Expected Output: Numbers 1 through 10.

Tables

Hints (3 available)

SQL Editor

Output

Click "Run" to see results...