In a recursive CTE, what is the role of the anchor member?
SQL Data AnalystHard
SQL Data Analyst — Hard
In a recursive CTE, what is the role of the anchor member?
Explanation
A recursive CTE consists of an anchor member (non-recursive SELECT) unioned with a recursive member; the anchor seeds the initial rows that subsequent iterations build upon.
