SQL - Common Table Expressions (CTEs)
Given a recursive CTE that calculates the total salary budget per manager including all subordinates, which additional SQL feature is essential to avoid infinite loops in case of circular references?
Given a recursive CTE that calculates the total salary budget per manager including all subordinates, which additional SQL feature is essential to avoid infinite loops in case of circular references?
hard📝 Application Q9 of 15
Step-by-Step Solution
Solution:
Step 1: Understand circular reference risk
If employees reference each other as managers in a loop, recursion can run infinitely.Step 2: Use termination condition
Limiting recursion depth or adding conditions to stop recursion prevents infinite loops.Final Answer:
A termination condition limiting recursion depth -> Option DQuick Check:
Prevent infinite recursion with termination condition [OK]
Quick Trick: Limit recursion depth to avoid infinite loops [OK]
Common Mistakes:
- Relying on DISTINCT to fix loops
- Adding ORDER BY which doesn't stop recursion
- Using GROUP BY in anchor member incorrectly
Master "Common Table Expressions (CTEs)" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes