Databases · Middle · Question 29 of 75
What does WITH RECURSIVE let you do?
- 1Run a query in an endless loop
- ✓Correct answer: Query hierarchies of unknown depth, like a category tree or an org chart
- 3Call a function from inside itself in JavaScript
Explanation
A recursive CTE has a base part and a part that refers to the CTE itself, repeated until no new rows appear. Guard against cycles in the data.