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 is the purpose of a table?

0 Answers  

How to create and drop temp table in sql server?

0 Answers  

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

What is the role that is required for killing a process What is the role that is required for creating a linked server

1 Answers   CarrizalSoft Technologies, IBM,

What is instead of dml trigger?

0 Answers  

How do I determine how many instances of sql server are installed on a computer?

0 Answers  

What is the difference between Userdefined function and stored procedure? Explain and give the example also

5 Answers  

How to connect of datebase with sql express.?

0 Answers   MCN Solutions,

What is table valued function and scalar valued functions?

0 Answers  

What is an etl file?

0 Answers  

Define full outer join in sql server joins?

0 Answers  

How to stop log file growing too big?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories