SQL Practice Logo

SQLPractice Online

Level 4 - Mid-LevelDebugging Questions

Debug: Recursive CTE Without Stop Guard

Fix potential infinite recursion by adding a stop condition. WITH RECURSIVE nums AS (SELECT 1 AS n UNION ALL SELECT n + 1 FROM nums) SELECT * FROM nums;