1 link collected from ibase.ru in 2012

Trees in SQL

Another way of representing trees is to show them as nested sets. Because SQL is a set-oriented language, this model is a better than the usual adjacency list approach you see in most textbooks.