select count(emp_id) from employee group by dept

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

Question Posted / priti

Answer Posted / priti

select count(emp_id) from employee group by dept_id;

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the system predefined user roles?

1044

How to use "in" parameter properly?

1075

what is insert all statement in sql

6526

Explain oracle’s server parameter file.

997

What is a synonym? What are its various types?

1110

What are the ansi data types supported in oracle?

947

How much memory your 10g xe server is using?

1104

How do you find current date and time in oracle?

1049

What is a partition in oracle?

1123

What do database buffers contain?

1038

How to start your 10g xe server?

1045

Differentiate between translate and replace?

1124

What is the usage of control file in oracle?

1090

What is the use of aggregate functions in oracle?

1026

What are the original export and import utilities?

1175