Ismael LR
Reputation: 79
Querying a tree structure for getting its children
I have a tree (nested set) table composed by persons in an organization. Each person has a rank in the organization. I'm trying to form a query that will get me the down line (children) for a person (all persons under that person) except if they are under a person that has the same rank or higher rank than that person. (But I want to keep the person with the same or higher rank). I don't need the exact query I'm just trying to get a hint or idea on how to make it happen.
Upvotes: 0
Views: 60
Answers (0)
Related Questions
- Getting all the children of a parent using MSSQL query
- Get nested children from parent's ID with SQL Server
- SQL: Get Parent Tree Hierarchy from child
- Hierarchical query to return all children with root parent
- SQL - nested set model - how do I find the deepest parents (not leaf nodes) of each branch
- How to get all children of several nodes in tree structure?
- Finding all children for multiple parents in single SQL query
- Is there a simple way to query the children of a node?
- sql query get all children and grandchildren
- get all nested children for a parent id