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 73783. 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 24194. 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 1959Post New Fintellix Interview Questions
What is meant by cloud trail?
What port number is 8080?
What is the basic difference between a cheque and a draft?
What is fast entry? : fi- general ledger
Where do I create jsp in eclipse?
Trafo ratio is 11kV/6.6kv,Vector group is YND11. What will be the effect if secondary is used for earthed system.
how to prepare site mix design
Do you know what is the difference between an array and vector?
What is the factory method in angular 2?
Are you comfortable shifting base?
Can you tell us more about ssh?
What is fairtrade??????????????
What is difference between dll and exe in c#?
What is collection class c#?
How do I find special characters in excel?