-
Get immediate reporting managers id
I have a table with employee ids and their manager ids. I want to get all their immediate reporting managers ids for that employee. I have used the connect by function. But its showing all the mangers like if the emp A reports to Mgr A and Mgr A reports to Mgr B. say if Mgr A also reports to Mgr C, then my current query retrieves all the Mgrs (A,B and C) but i need only Mgr A and B. Kindly help me here.
Question asked by visitor Suresh
-
Re: Get immediate reporting managers id
Kindly post with your table structure with all the relations .
also post the query that you have tried to solve this .
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules