PL/SQL GROUP BY inside a SUBQUERY

select   d.dname ,
           t.job,
           t.cnt
 from   dept d,
          (select  deptno,
                      job,
                      count(empno) cnt
             from  emp
      group by  deptno,job ) t
where  t.deptno = d.deptno;

Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"

Getting Umbraco Content - IPublishedContent vs IContent vs Node vs Document