2 Replies Latest reply on Aug 4, 2015 2:25 PM by Gary Graham-Oracle

    InLine Query


      Hi Team


           I what to take count of employee  and department , course and need the out put as shown below


      Select Employee as summary , count(Name)  Count From employee;


      select department as summary , count(dname) count from department;


      select course as summary , count (coursename) count from cousre_offered;


      I want the output as


      summary  count

      Employee  10

      department 4

      course        5


      Like this please advise