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 85993. 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 30954. 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 2654Post New Fintellix Interview Questions
What is the best Code-coverage tool available for Play and Scala based applications?
How does AI improve surgical outcomes?
Describe the reason for not modifying the existing base tables?
What is the new security features added in sql server 2016? : sql server security
What is variable view?
in which situation ion pair agent require to use?
Explain the differences between one-way binding and two-way binding.
How do you convert psd to drupal theme?
how to prepare the balance sheet of private ltd. company & what roll should be play by Income tax, compnay law & accounting standard in India & world.
How can we migrate PeopleSoft project from one environment to another?
What do you mean by provider?
if a min thread has finished execution what happens ? a) it exits b) it wait for other threads c) becomes inactive ... etc etc
How do you kill a process?
What is the use of EventMessage.java?
How do you copy table from excel to word and keep formatting?