How many joins are there in Sql-Server?

 Posted by Rajesh_Kumar on 1/22/2014 | Category: Sql Server Interview questions | Views: 1337 | Points: 40
Answer:

There are following joins in Sql Server:

1). Inner joins: It returns all rows when there is at least one match in both tables
2). Non-Equi joins: It uses comparison operator instead of the equal sign like >, <, >=, <= along with conditions.
3). Outer joins
a). Left outer joins: It return all rows from the left table,and the matched rows from the right table
b). Right outer joins: It return all rows from the right table,and the matched rows from the left table
c). Full outer joins: It displays all the matching and non matching rows of both the tables.
4). Self joins: Joining the table itself called self join.It happens in the same table.
5). Cross joins: A cross join that produces Cartesian product of the tables.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response