Home Forums SQL Server 2005 SQL Server Newbies List all the departments that don’t have any employees RE: List all the departments that don’t have any employees
Ian Massi
SSCertifiable
Points: 5931
More actions
October 31, 2008 at 6:05 am
#892255
I would group by department having count(*) = 0.