How to find possible loops in hierarchy using sql

Using recursive queries...
Hierarchies are quite difficult to represent correctly in a flat structure such as that of a SQL Table. Recently, I had to work on finding possible looks in a db hierarchy. In this post I will share with you the tips I gathered all around the internet to solve this problem efficiently. Read more