Download 100% FREE Office Document APIs for .NET
DotNetFunda.com
Online: 1558
Home > Codes >

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 : 421
Post Code | Search Codes | Code Home  

SELECT * FROM EmployeeTable
WHERE DepartmentID IS NULL   -- where the dept ID is empty
Alert Moderator 
Bookmark It

Comments or Responses

Login to post response

Latest Code Snipptes