Give an example of Full Outer Join?

Question Posted / parli jain

1 Answers
5585 Views
IBM, I also Faced
E-Mail Answers

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 does sql stand for?

0 Answers

what is HASH join?

2 Answers Genpact, HCL,

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers Zensar,

what is the difference difference between procedure and packages

2 Answers 3i Infotech, Oracle,

Explain how to use transactions efficiently : transact sql

0 Answers

What are all the ddl commands?

0 Answers

What are the differences between in and exists clause?

0 Answers

How can I pass the inner procedure value to outer procedure ?

2 Answers

What is sql*loader and what is it used for? : aql loader