What is the output of the query,
SELECT * FROM Employee_ksm E INNER JOIN Department D ON E.DepartmentId=D.DepartmentId

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

This query is used when you need to join two tables and get the ouput based on where clause. Suppose you have two tables one for maintaining your Employee details and the other for Departments present in your company.
When you want to know in departments the Employee is present then you can use this query.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response