Hierarchical Data
Everything on SkillVeris tagged Hierarchical Data — collected across the glossary, study notes, blog, and cheat sheets.
2 resources across 1 library
Interview Questions(2)
What is a Recursive CTE and When Would You Use One?
A recursive CTE is a Common Table Expression that references itself, repeatedly building on its own previous output until no new rows are produced, making it t…
What is a Self-Join and When Would You Use One?
A self-join is a regular join where a table is joined with itself, typically by giving the table two different aliases so rows can be compared against other ro…