Find Details of Employee in SQL

hi,

Try following Query....

create  table #emp
(
 employeeId int,      
 lastName varchar(25),            
 firstName varchar(25),          
 middleName varchar(25),        
 jobId int,         
 managerId int,      
 hireDate date          ,
 salary int,         
 comm varchar(25),   
 departmentId int
)

insert into #emp
values(7505,'DOYLE','JEAN','K','671','7839','4/4/1985','2850',NULL,30               ),
(7506,'DENNIS','LYNN','S','671','7839','10/5/1985','2750',NULL,30              ) ,
(7507,'BAKER','LESLIE','D','671','7839','9/6/1985','2200',NULL,40               ),
(7499,'ALLEN','KEVIN','J','670','7698','12/4/1984','1600',300,30               ),
(7521,'WARK','CYNTHIA','D','670','7698','4/2/1985','1250',500,30               ),
(7369,'SMITH','JOHN','Q','667','7902','12/5/1984','800',NULL,20)

select * from #emp

Select a.Month,A.Year,COUNT(1) As NoOfEmp from (
select year(hireDate) as Year,MONTH(hireDate) as Month, employeeId from #emp) A
Group by A.Month,A.Year
Order by A.Year,A.Month

select departmentId from #emp
group by departmentId having COUNT(1) > 3

select COUNT(1) from #emp
group by MONTH(hireDate) having MONTH(hireDate) = 12

select COUNT(1) from #emp
where MONTH(hireDate) in (1,9)

select COUNT(1) from #emp
where year(hireDate) = 1985

Select a.Month,A.Year,COUNT(1) As NoOfEmp from (
select year(hireDate) as Year,MONTH(hireDate) as Month, employeeId from #emp) A
Group by A.Month,A.Year having A.Year = 1985
Order by A.Year,A.Month

select COUNT(1) from #emp
where year(hireDate) = 1985 and MONTH(hireDate)= 3

select departmentId from #emp
where year(hireDate) = 1985 and MONTH(hireDate)= 4
group by departmentId having COUNT(1)>=3

it might help you.