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
8792 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

What is basic structure of pl sql?

1132

Can we commit inside a trigger?

1047

Does postgresql run on the cloud?

1222

what is an index? : Sql dba

1045

What is faster join or subquery?

1068

Why do we need unique key in a table?

1008

What is dense_rank?

989

What is the use of non clustered index?

1045

How do you declare a variable in pl sql?

1071

What is nosql example?

1096

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1068

What is the difference between microsoft access and sql?

1076

how mysql optimizes distinct? : Sql dba

1125

What is difference between sql and mysql?

1197

What is rtm in testing?

1175