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
2 73933. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);
1 24284. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;
1 1966Post New Fintellix Interview Questions
How many items should be on a wedding registry?
Explain the function of Finance Department.
What does ctrl d do in excel?
How do you instruct your compiler to print the contents of the intermediate file showing the effects of the preprocessor?
What goals do you have in your career?
How can we load multiple tables in to dataset?
Explain about websphere packages?
Tell me what is trimming?
Explain about Connection factory interface?
Why does not c have an exponentiation operator?
Tell me in accounting, vat abbreviates what?
What is the latest version of php?
where can the transformer having vector group Yny0 be used??
Differentiate between data mining and data warehousing?
What was the first windows version?