2 Replies Latest reply on Aug 9, 2016 2:43 AM by 2662398

    How to get the manager details below the top most manager


      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.