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

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 Answers  

How cand Optimize SQL Server Stored Procedures

1 Answers  

Differences between functions and stored procedures?

8 Answers   247Customer, Accenture,

How to remove duplicate rows from table?

0 Answers  

What is sqlservr.exe - process - sql server (sqlex?press)?

0 Answers  

Explain sub-query?

0 Answers  

What command is used to delete a table from the database in the sql server and how?

0 Answers  

What is lock escalation? : sql server database administration

0 Answers  

What is SCOPE_IDENTITY() in sql

4 Answers   Cap Gemini,

what is physical sort data and logical sort data in index?

2 Answers  

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

What is attribute? : sql server analysis services, ssas

0 Answers  

For more SQL Server Interview Questions Click Here
Categories