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

    How to get the manager details below the top most manager

    2662398

      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