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 87943. 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 32124. 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 2800Post New Fintellix Interview Questions
What exactly do you know about Blue Prism and Automation Anywhere in RPA?
What samples and sample databases are provided by microsoft?
What is water pollution presentation?
please tell me when co. owner invest money in his family members bank a/c. not any transaction came in business can we do this bank statement in tally ?
What’s Canonical’s role in OpenStack?
Explain what is string interpolation in angular.js ?
What is GainSpan’s GS2000 Protocol for the Internet of Things (IoT)?
How to create an ajax website using visual studio?
What is Mobile Voice Access and Unified mobility?
How is double fertilisation present in some gymosperms when it is a characteristic of angiosperms?
What are the attributes of process definition?
What is nonatomic in ios?
What are the methods used to provide effects in jquery?
How many valves is tomcat configured with?
What are selenium tests normally named (as displayed at the top of each test when viewed from within a browser)?