Hiii Try this query it will give you the answer select count(1) as

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 / madhu sudhan g

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

Answer Posted / madhu sudhan g

Hiii

Try this query it will give you the answer

select count(1) as EmpCount,EmployeeName from EMP
GROUP BY DepartmentName

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know what is sql injection?

939

What are the new features of sql server 2008 r2 reporting service?

193

What happens if the update subquery returns multiple rows in ms sql server?

1058

What are points to remember while using the fillfactor argument?

909

Explain what are various ways to enhance the ssrs report?

993

Why do we use non clustered index?

1010

Explain primary key, foreign key and unique key?

936

What are the different types of replication you can set up in sql server?

985

Can group functions be mixed with non-group selection fields in ms sql server?

892

Explain use of expression builder.

953

How would we use distinct statement? What is its use?

1024

How to retrieve error messages using mssql_get_last_message()?

994

How to test values returned by a subquery with the in operator?

1135

Explain differentiate between a having clause and a where clause?

854

What are tables in sql server?

965