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 difference between sql query and google query?

10 Answers   TCS,

What is a livelock?

0 Answers  

How exceptions can be handled in sql server programming?

0 Answers  

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 Answers   DELL, i Tech, Infosys, Siemens, TCS,

What are the different types of queries?

1 Answers  

Which tcl commands are available on the sql server?

0 Answers  

How do I find the query plan in sql server?

0 Answers  

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

What is the difference between deallocate cursor and close cursor?

0 Answers  

What are different types of schemas?

0 Answers  

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

How sql server enhances scalability of the database system?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories