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

Explain constraining triggers.

1104

How can I get column names from a table in oracle?

1055

Does facebook use oracle?

1040

What is transport network substrate (tns) in oracle?

1049

Why is oracle database so popular?

1015

What do database buffers contain?

1042

What are the oracle built-in data types?

1085

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2271

What is raw datatype in oracle?

1145

Explain the use of grant option in exp command.

1067

How can you use check constraints for self referential integrity?

975

Explain what are the type of synonyms?

1134

How to connect to the server with user account: sys?

1027

What is an oracle transaction?

1156

What is open database communication (odbc) in oracle?

1007