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

Mention the uses of stored procedures.

0 Answers  

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

What is data block and how to define data block size?

0 Answers  

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

3 Answers   247Customer,

Which institute is best for SQL Server 2005 Training?

6 Answers  

Explain error handling in ssis?

0 Answers  

What happens if null values are involved in boolean operations?

0 Answers  

What is the difference between join and inner join?

0 Answers  

Detail about query optimizer?

0 Answers  

How do you troubleshoot errors in a SQL Server Agent Job?

0 Answers  

How would you use user_constraints table in DB?

0 Answers   Wipro,

For more SQL Server Interview Questions Click Here
Categories