how to get the no employee in each department including the dept which has 0 em

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

how to get the no employee in each department including the
dept which has 0 employee

Question Posted / gautam

5 Answers
7346 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to get the no employee in each department including the dept which has 0 employee..

Answer / mahesh madala

select d.deptno,count(ename)no_of_emps from emp e,dept d
where d.deptno = e.deptno(+)
group by d.deptno

Is This Answer Correct ?

5 Yes

0 No

how to get the no employee in each department including the dept which has 0 employee..

Answer / shailesh

select d.department_id,count(e.employee_id) from
departments d
left outer join employees e
on(e.department_id=d.department_id)
group by d.department_id;

Is This Answer Correct ?

1 Yes

0 No

how to get the no employee in each department including the dept which has 0 employee..

Answer / sanjay pradhan

select d.deptno,count(ename)employees from emp e,dept d
where d.deptno = e.deptno(+)
group by d.deptno

Is This Answer Correct ?

0 Yes

0 No

how to get the no employee in each department including the dept which has 0 employee..

Answer / sudipta santra

select distinct dept_no, nvl(count(emp_no),0) from dept
group by dept_no;

Is This Answer Correct ?

0 Yes

3 No

how to get the no employee in each department including the dept which has 0 employee..

Answer / priti

select count(emp_id) from employee group by dept_id;

Is This Answer Correct ?

0 Yes

3 No

Post New Answer