Building a tree structure with a recursive query in SQL
When modeling dataset we often need to represent hierarchical relation between objects. If the information is easy to store in a classical RDBMS querying the full hierarchical structure might not be obvious at the first glance. In this article we…