Display the department name and total number of employees in each department.

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

Comments or Responses

Login to post response