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 are actual parameters and formal parameters?

770


What is sql key?

684


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

719


What is the sql case statement?

745


How many columns should be in an index?

703






What is a table in a database?

780


how to see the create table statement of an existing table? : Sql dba

729


How many types of privileges are available in sql?

961


where are cookies actually stored on the hard disk? : Sql dba

783


Why are indexes and views important to an organization?

674


Is pl sql still used?

680


What is form and report?

705


How do I find duplicates in a single column in sql?

728


How can I see all tables in sql?

726


Can we call procedure in select statement?

732