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 87913. 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 2799Post New Fintellix Interview Questions
What are the different ways of deployment in salesforce?
What are the authorization groups and how to create them?
How are product categories represented in r3?
will u pls suggest me which books should i prepare for group 2. and where will i get that books. pls pls
What is a floating element in css?
Which port does netflix use?
How can you install the kernel32 dll file?
What is normalization and why it is used?
What are selectors and wildcards in uipath?
How does the internal audit differ from an external audit?
Does nodejs need java?
What does it mean to sort an array?
Which capacitor is preferred for high voltage and frequency?
why expedia?
What are the Differentiate between abstraction and encapsulation.