select Dept_Name,count(Dept_Name) as 'No. of employee' from

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 / rajkumar v

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

Answer Posted / rajkumar v

select Dept_Name,count(Dept_Name) as 'No. of employee'
from tbl_dept group by Dept_Name having COUNT(*)>1

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to handle error or exception in sql?

969

Explain the truncate command?

962

What are key constraints?

960

Can you edit the .rdl code associated with a linked report?

160

What is a partition key?

933

How will you make an attribute not process? : sql server analysis services, ssas

1065

Explain the usage of floor function in sql server.

946

What is the ‘fillfactor’?

952

what is create database syntax? : Sql server database administration

1086

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

980

What are rows and columns?

1000

How to fetch the next row from a cursor with a "fetch" statement?

1056

How to create a testing table with test data in ms sql server?

1064

Define candidate key, alternate key, and composite key.

906

What are the differences between stored procedure and the dynamic sql?

1067