select dept no, count(dept no)from employee group by dept no.

hi friends please answer this question ASAP:-
how to count the no. of employee in a each department
or
no. of employee in each location by using emp/dept table

Question Posted / sushanta

7 Answers
8447 Views
Indecomm, I also Faced
E-Mail Answers

Answer Posted / sushanta

select dept no, count(dept no)from employee group by dept no.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an indexed view?

965

How many types of keys are there?

1035

What is the use of RDBMS?

1007

Can we use where and having clause together?

1050

Is oracle faster than sql server?

958

What is a matrix in ssrs?

153

How check triggers in sql server?

998

How fixed length strings are truncated and padded?

981

Name three of the features managed by the surface area configuration tool? : sql server security

998

Please differentiate between a local and a global temporary table?

1012

Suggest a method of joining two tables.

1165

What is the need for group functions in sql?

1090

What are character string data types in ms sql server?

1260

How do I view a stored procedure in sql server?

986

How do you make a trace?

1030