Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLrecursive CTEsSingle-choice MCQ

What goes wrong with this recursive CTE intended to walk an org chart, and what is the usual safeguard?

WITH RECURSIVE chain AS ( SELECT id, manager_id FROM emp WHERE id = 7 UNION ALL SELECT e.id, e.manager_id FROM emp e JOIN chain c ON e.id = c.manager_id ) SELECT * FROM chain;