it will gives result as 1 and null

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A
Full outer join ( select 1 B from dual Union select 2 B from dual)B
On A.A=B.B

Question Posted / kuldeep123

2 Answers
8691 Views
Fintellix, I also Faced
E-Mail Answers

Answer Posted / kuldeep123

it will gives result as 1 and null

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can a view be mutating? If yes, then how?

1028

What is the difference between delete and truncate commands?

1042

What do we need to check in database testing?

1018

what are integrity rules?

1027

What are commit, rollback, and savepoint?

996

What is the use of count (*) in sql?

1054

Why we use cross join?

953

Is sql microsoft?

1058

how mysql optimizes distinct? : Sql dba

1080

What is the difference between an inner join and an outer join?

1027

What does rownum mean in sql?

1026

What is a string data type in sql?

1045

What are instead of triggers?

1046

What is sql key?

995

Which software is used for pl sql programming?

990