This content has been marked as final. Show 3 replies
Edited by: jeneesh on Dec 11, 2012 12:35 PM
start with ( manager_id ='171' or ( employee_id='171' and '171' not in ( select distinct manager_id from employees where manager_id is not null ) ) )
There is no row with manager_id=171, so your start-condition will never become true.1 person found this helpful
You can try
... start with employee_id=100 /* same as manager_id is null */ ...
... start with employee_id=171 ...
Edited by: hm on 10.12.2012 23:09
Thanks Jeenesh and HM