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

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1993

Explain Normalization and DE normalization

1160

Name and describe few console utilities for ssrs?

288

explain different types of constraints? : Sql server database administration

1000

Explain the dirty pages?

1050

According to you what goes into making the best database administrator? : sql server database administration

1022

How to integrate the ssrs reports in application?

1039

How to bind a view to the schema of the underlying tables?

1046

How to get the definition of a stored procedure back?

1020

What are the properties of the relational tables?

928

what is sql server? : Sql server database administration

1042

How many databases instances are there in sql server 2000?

1166

Explain the types of indexes.

1294

Describe how to use the linked server?

1201

What do you understand by user-defined function in the sql server?

1009