SQL: Recursive CTE
In some scenarios, there is a need to store hierarchies within the database, such as the corporate organizational chart or product categories of an e-commerce store. Although relational databases allow hierarchies to be modeled appropriately, querying them can be difficult and burdensome. Recursive CTEs were introduced to address these needs. We will study their syntax and application through an example, not before also evaluating other technological alternatives such as NoSQL databases.
