Response to: Employee Manager Hierarchy
Revision 2
What about THIS
select distinct managerid from EMP where managerid <= (select managerid from EMP where empid=7)
You could try building
Recursive CTE[
^] for data hirarchy.
Posted 29-Dec-10 0:10am
by
Hiren solanki.