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

    InLine Query

    A.T

      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

       

      Thanks

      AT