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 86133. 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 30974. 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 2660Post New Fintellix Interview Questions
How to get Retrieving a Cookie in Laravel ?
Mention what are the t-codes for creating, changing and summarizing bom?
How is broadcast receivers implemented?
What is an ai technique?
Explain, what is the use of “enter” and “exit” selection in d3.js ?
Are all members of transporter families confined to a particular organelle or to the plasma membrane, or are some family members found throughout cellular compartments in eukaryotes?
What is "per call" instance mode in wcf?
What are system databases in ms sql server?
What does f5 do in powerpoint?
Which database is best with python?
What are ios protocols?
Who makes the struts?
What do you understand by the terminology robotic automation?
What exceptions occur during serialization?
What is 'banknet'?