Calculate number of employee

Feb 11 2012 11:38 PM

Hi friends...

I have a table like this,...

ID EMPName Dept Sal
1 a x 10000
2 b y 4000
3 c x 2500
4 d y 5000
5 e z 8500

I want to calculate the number of employee in department wise in single query ? Please explain ?

Thanks.........

Answers (4)

Creating a custom search stored procedure

Check Constraint in Sql Server