Can we have WHERE CLAUSE in SELF JOIN?

 Posted by vishalneeraj-24503 on 11/28/2013 | Category: Sql Server Interview questions | Views: 1081 | Points: 40
Answer:

Yes. We can write Where Clause in Self Join. As self join joins table itself. So it will produce result based on condition,which we supply in where clause.

For example:-
Select * from employee_master a,employee_master b where a.employee_id = b.employee_id;


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response