sunanda

hi (aspnetguy)..Thanks a lot for the code.Regardssunanda

hi all.. help me in writing a SQL Querythe table(EMP) has some columns such as Emp_name, Emp_id, Dept etcI want to count number of employees in each dept. the out put should look like this. Dept. Count aaa 10 bbb 15 ccc 10Thanks in advance.Regardssunanda