Calculate number of employee

Accepted answer

Vineet here is your answer:

create table record
(
ID int ,
EMPName varchar(25),
Dept varchar(20),
Sal int
)

Select Dept,count(*) as NumberOfEmployee from record group by Dept;

Hi Vineet,

SELECT Dept, COUNT(*) AS ' Number of employees'
FROM employee
GROUP BY Dept
ORDER BY Dept DESC

Thanks

Thanks to all.....

Hi

You can try this:

SELECT DISTINCT EMPName FROM TABLE WHERE Dept LIKE 'X';