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

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 difference between db2 and sql?

533


How can you fetch common records from two tables?

590


What are different types of keys?

524


What is the difference between row level and statement level trigger?

521


how to check myisam tables for errors? : Sql dba

605






What is the advantage of index in sql?

541


What is primary key sql?

546


What is the difference between pl and sql?

545


What does the acronym acid stand for in database management?

546


How many primary keys can a table have?

534


What is the difference between microsoft sql and mysql?

512


Is mariadb nosql?

586


how can we destroy the session, how can we unset the variable of a session? : Sql dba

554


Which join condition can be specified using on clause?

517


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

603