SQL Developer

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