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 86913. 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 31354. 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 2716Post New Fintellix Interview Questions
How catalyst converter works?
Which messaging is generally used in cases where a message is published by a producer and consumed by multiple subscribers?
Which is the base class for all the classes in .net framework?
Is it possible to use the same metastore by multiple users, in case of the embedded hive?
How do you copy a folder?
What is normalization? What are different type of normalization?
Can you explain the meaning of aggregation and composition
What is google penguin algorithms?
How you will load or add a model in codeigniter?
Why node js is different from angular js?
What is the use of Computers in a Bank?
What qualities would you look for in a candidate if you were hiring for this position?
Is access good as a database?
Explain the function of alert manager?
Explain the role of Streams API?