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

    How to select department with employess in same row


      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