Sunday 6 October 2013

01. Write a query to display EmployeeID of those employees who belong to the department, Tool Design.

select EmployeeID from HumanResources.EmployeeDepartmetHistory
where DepartmantID in (select DepartmentID from HumanResources.Department
where name ='Tool Design')

No comments:

Post a Comment