Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is Full Outer Join?

Question Posted / g.ramesh

Answers were Sorted based on User's Feedback



What is Full Outer Join?..

Answer / g.ramesh

It produce Result Set which contains matched rows and both
side tables unmatched rows.

Is This Answer Correct ?    2 Yes 0 No

What is Full Outer Join?..

Answer / pushpa

Join interms of database combining two or more tables.
we have many joins.
inner join,self join,outer join,cross join.
in outerjoin we have three types.
left outer join
right outer join
full outer join
if we want to join two tables--
use left outer join- get the matched columns of two tables & ramaining columns of left hand side table of the join statement.

use right outer join- get the matched columns of two tables & ramaining columns of right hand side table of the join statement.

use full outer join- get the matched columns of two tables & ramaining columns of left hand side table and right hand side table of the join statement.

Is This Answer Correct ?    1 Yes 0 No

What is Full Outer Join?..

Answer / naren

matching columns of left and right tables and unmatched columns of both tables is displayed.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the authentication modes in sql server? How can it be changed?

0 Answers  

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  

What is the difference between resultset and resultsetmetadata?

0 Answers  

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

How will u get 5 years back record?

5 Answers  

How to genrate automaticlly empid like gt001

4 Answers  

What are translations and its use? : sql server analysis services, ssas

0 Answers  

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

Why do we use trigger?

0 Answers  

How to apply cascading referential integrity in place of triggers?

0 Answers  

What is attribute? : sql server analysis services, ssas

0 Answers  

How can I know what locks are running on which resource?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories