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
8339 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

What is difference between unique and primary key?

889

How would you add a section to a table?

1012

Is sql server is free?

951

Define self join?

1014

What is clustered index

986

How to Sync Two SQL Azure Databases?

119

What is buffer cash in sql server?

1138

Do you know what is replace and stuff function in sql server?

989

can a table be moved to different filegroup? : Sql server administration

943

Explain triggers in sql?

927

why would you call update statistics? : Sql server database administration

1060

What is the default Port No on which SQL Server listens?

1108

How dts is used to extract, transform and consolidate data?

1060

How to select an exiting database using mssql_select_db()?

963

What encryption security is available in sql azure?

101