query to fetch the all the employee details who do not belong to any department

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 191

SELECT * FROM EmployeeTable
WHERE DepartmentID IS NULL -- where the dept ID is empty

Comments or Responses

Login to post response