tags:

views:

16

answers:

0
Q: 

Hierarchy problem

i have a table which contains the following fields

•Supervisorid •Empid This is just like a referral program. A guy can refer 2 guys under him i.e, 3 is referring three guys namely 4 5 similarly 4 is referring 9 10 and 11 likewise 8 is referring 12, 13 it goes like this..

I want a query to get all EmpId under Supervisor 3

related questions

CTE to traverse back up a hierarchy?
Best practice for naming subclasses
How to maintain several translations of a documentation set written with Sphinx?
What is the best way to store data on a TreeView Node?
Why is my Linq to Entities code duplicating rows?
Ordering hierarchy from recursive query results in SQL 2005
Exchange Server Organizational Structure
PHP/MySQL - building a nav menu hierarchy
How can I query hierarchies with LinqToSQL?
Is there a good, re-usable parser that converts a string into a hierarchy of lists?
How can I select all leaf nodes in a SQL hierarchy under a given node?
CSS hierarchy classes and IDs
Using master pages with multiple entities
What is your method of "folksonomy" tagging for files on your local machine?
How to build a tree view with PHP / SQL?
LINQ grouping/subquery to fill a hierarchy data strcuture
Building hierarchy objects from flat list of parent/child
Build hierarchical html tags in PHP from flat data.
Collection type for representing a hierarchial structure in .Net 3.5
How would you design a tree view that collapses around an arbitrary middle element?
Oracle Hierarchical Query Performance
Linq to Sql - Hierarchical Query to Find Ancestors
How do you sort a tree stored using the nested set model?
Select products where the category belongs to any category in the hierarchy
SQL to reorder nodes in a hierarchy