Calculate number of employee
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.........