Result of the following query,
SELECT * FROM Employee_ksm WHERE Employee_ksm.DepartmentId IN(SELECT DepartmentId FROM Department)

 Posted by Kmandapalli on 1/22/2014 | Category: Sql Server Interview questions | Views: 1582 | Points: 40

When we want to get the records from both the tables where the DepartmentId in Employee_ksm matches the DepartmentId in Department table.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response