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 PLSQL
  2. Suggest New Category

Give an example of Full Outer Join?

Question Posted / parli jain


Give an example of Full Outer Join? ..

Answer / senthil kumar

6. full outer join : ALL UNMATCHED DATA FROM BOTH TABLES

SELECT * FROM TABLE A FULL OUTER JOIN TABLE B ON (A.ID= B.ID)
Ex:

TABLE A
NO NAME 1 X
2 Y
5 Z

TABLE B
NO NAME 1 XX
2 YY
3 ZZ
4 AA

OUTPUT:
NO NAME NO NAME
1 X 1 XX
2 Y 2 YY
3 ZZ
4 AA
5 Z

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is primary and foreign key?

0 Answers  

What is duration in sql profiler trace?

0 Answers  

what is a trigger in mysql? Define different types of trigger. : Sql dba

0 Answers  

How to execute OS(operating system) command from pl/sql?

3 Answers  

What is trigger explain with example?

0 Answers  

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

What is Histogram?

0 Answers   NIIT,

What is a design view?

0 Answers  

Explain the advantages and disadvantages of stored procedure?

0 Answers  

What are instead of triggers?

0 Answers  

Describe different types of general function used in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories