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

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

Question Posted / mahesh madala

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2130

What are the different types of failures that occur in Oracle database?

1016

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1670

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1873

Can we insert data in view oracle?

963

What is system global area (sga) in oracle?

928

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2577

How to export data to a csv file?

1207

How to bring a tablespace offline?

1001

What is integrity and what is constraint??Explain with example

2215

What is archive log in Oracle?

1071

How to define a variable of a specific record type?

1022

How to start instance with a minimal initialization parameter file?

992

Can we write insert statement in function in oracle?

1027

How to use fetch statement in a loop?

974