What does the following recursive CTE produce? WITH RECURSIVE nums AS ( SELECT 1 AS n UNION ALL SELECT n + 1 FROM nums WHERE n < 5 ) SELECT n FROM nums

Question

SQL Fundamentals — Hard

What does the following recursive CTE produce? WITH RECURSIVE nums AS ( SELECT 1 AS n UNION ALL SELECT n + 1 FROM nums WHERE n < 5 ) SELECT n FROM nums

Accepted Answer

The recursive CTE generates rows with increasing numbers from 1 to 5. The initial value is 1, and then each subsequent row adds 1 to the previous value until it reaches 5.