Self-join Queries for hierarchical data
88754
SELECT clause with self joining table
41821
How do I do reflexive self-join relationships in ActiveRecord?
128027
Converting hierarchies of rules to associations
50577
hierarchical retreival of records in postgresql
134580
basic recursive query on sqlite3?
92687
Join vs. sub-query
143514
How to perform Global search on account hierarchy to display related records
101389
Get 10+ Level Hierarchy Relationship
49426
Best design for a tree-like structure database
69565
Finding contiguous ranges in grouped data
55290
join syntax / style performance consideration
79801
Best way to capture historical changes between levels in a dimensional hierarchy
136968
More Efficient Spatial join in Python without QGIS, ArcGIS, PostGIS, etc
119406
How to get last level of a hierarchical list, group by some field
57398
Where does TREE(n) sit on the Fast Growing Hierarchy?
7554
How do I create a cross reference table/query for my data?
109525
query syntax to select every multiple of nn record (shapefile)