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 87043. 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 31464. 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 2724Post New Fintellix Interview Questions
What is truncate table?
What is java naming and directory service?
Enlist the disadvantages of query.
FAVOURITE PASTTIME BET.PRE-BOARD AND BOARD?
What is the abap program name to process the batch input session automatically? : abap bdc
Where did you use data mover?
How to capture screenshot in webdriver?
How to backup wordpress root files?
Does pandas recognize dates when importing data?
What is sap abap data classes?
Why blockchain is a trusted model of the transaction?
Write the simplified mathematical Taylor's expansion for f(x,y)
What does mappedby mean in hibernate?
What are the three sections of a vuser script and what is the purpose of each one?
What do you mean by cascading?