[Solved] Identify the error in this recursive CTE:WITH RECURSIVE count_up AS ( SELECT 1 AS num UNION ALL SELECT num + 1 FROM count_up ) SELECT * FROM count_up WHERE num <= 3; | SQL

SQL - Common Table Expressions (CTEs)

Identify the error in this recursive CTE:

WITH RECURSIVE count_up AS (
  SELECT 1 AS num
  UNION ALL
  SELECT num + 1 FROM count_up
)
SELECT * FROM count_up WHERE num <= 3;

AUsing UNION instead of UNION ALL

BIncorrect anchor query syntax

CWrong column alias in SELECT statements

DMissing stopping condition inside the recursive part causing infinite recursion

Step-by-Step Solution

Solution:

Step 1: Check recursive part for stopping condition
The recursive SELECT lacks a WHERE clause to stop recursion, causing infinite loop.
Step 2: Understand WHERE clause placement
The WHERE clause outside the CTE filters final results but does not stop recursion inside CTE.
Final Answer:
Missing stopping condition inside the recursive part causing infinite recursion -> Option D
Quick Check:
Stopping condition must be inside recursive CTE [OK]

Quick Trick: Put stopping condition inside recursive SELECT, not outside [OK]

Common Mistakes:

Master "Common Table Expressions (CTEs)" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this recursive CTE: