5 Replies Latest reply on Aug 4, 2015 2:16 PM by 3003840

    How to select department with employess in same row

    3003840

      Hi everyone,


      I need to do this  query,


      Suppose we have 2 departments with n employees on each department


      I need to select departments with just 2 employees in the same row, here example


      Dep1   depName  Emp1Dep1 Emp2Dep1


      Dep2   depName  Emp1Dep2 Emp2Dep2


       


      I did this but with function returning the Emp1Dep1 Emp2Dep1


      Is there a best way to do this?


      NB: 11g database


      Thanks