Suppression with GROUP BY


How do I change this SELECT so it is the criteria used for deleting?

SELECT COUNT(empid), empid, status, deptid from tableA
GROUP BY empid, status, deptid HAVING status is null and deptid = 5

What do you want to delete?

If simply records with NULL status in deptId 5, using

WHERE status is NULL and DeptID = 5

Not very clear if you are looking for more than that...