HOW MANY TYPES OF JOINS AVAILABLE IN SQL SERVER?

 Posted by Sriramnandha on 5/23/2012 | Category: Sql Server Interview questions | Views: 4749 | Points: 40
Answer:

There are Five type of joins available in sql server

1) INNER JOIN
There are Two tables having Common column values go with inner join.
2) OUTER JOIN(LEFT OUTER JOIN,RIGHT OUTER JOIN)
Left outer join: Taking Left side of the values checking in to Right side Taking Right side values checking with left side call right outer join.
3) FULL JOIN
Full join combined with left outer join and right outer join.
4) CROSS JOIN
Cross join is an Cartesian Product.its look matrix format.
5) SELF JOIN
join within the table is called self join..


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response

More Interview Questions by Sriramnandha