Hi Team,
I have a below requirement where i need to get the manager name who reports to top manager.
For ex:
-------
Employee-->Manager-->Next Level Manager-->Next Level Manager-->Next Level Manager (Top Manager)
1. John David Michael Johnson Paul
2. Andy Rock Murray Debbie Paul
In Select statement I need to display data like below
Employee Name Employee Number Job Manager
John 1234 xyz Johnson
Andy 7890 abc Debbie
Please suggest.
Thanks,
Poli