Viewing post 1 (of 1 total)
select COUNT (empl.EmpID) as 'Number of Employees in Section',dep.DepName
from Employee empl
INNER JOIN
Department dep
on dep.DepID=empl.DepID
group by dep.DepName
having
COUNT(*) >10
April 15, 2011 at 5:51 am
#1312051