Display the department name along with total salary in each department.

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 682
select dname,sum(sal) from emp,dept where emp.deptno=dept.deptno
group by dname;

Comments or Responses

Login to post response