select d.dept_ID ,count(empid) from Emp a inner join Department b on a.emp

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 / ezhumalai

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

Answer Posted / ezhumalai

select d.dept_ID ,count(empid) from Emp a inner join Department b
on a.empid=b.empid
group by d.dept_ID

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why are you getting errors when creating a new odbc dsn?

1200

Explain the dirty pages?

981

What is table join?

1094

What is the fastest way to permanently delete a 1 million row table named customers?

1234

What is change tracking in sql server?

978

What happens to a statement batch if there is a compilation error?

937

What are the different acid properties?

1045

What are the types of ssrs?

145

How can I create a report based on a query? : sql server management studio

996

What do you mean by data integrity?

1043

What does it mean to be in union?

912

How many servers can we create in a single subscription?

160

Mention what are the core components of ssrs?

321

How do I start sql server 2016?

878

How would you use user_constraints table in DB?

984