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

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

Question Posted / sudipta santra

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

Please Help Members By Posting Answers For Below Questions

What are the different types of record groups in oracle? Explain each of them

1026

What are joins, explain all types of joins?

2299

How to view existing locks on the database?

1053

State and explain the different types of data models?

944

What is the use of file param in imp command?

1165

What is a named program unit?

1086

How to define an oracle cursor variable?

1027

What is raw datatype?

1136

List out the difference between commit, rollback, and savepoint?

1033

How to get execution path reports on query statements?

987

What is analyze command used for?

1073

Can I create users through internet explorer in oracle 10g?

1084

WHAT IS ecc 6.0

2147

How to pass parameters to procedures in oracle?

1042

What do you mean by redo log file mirroring?

1032