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 87133. 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 31524. 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 2729Post New Fintellix Interview Questions
Are foreign destinations handled within foreign jms messages? : BEA Weblogic
What are the types of sensors?
Name the instrument used for sequencing proteins automatically?
Why rate of condensation is higher on a polished surface compared to rusty surface ?
What is the difference between multicast and unicast?
How to run a group of test cases using testng?
How many modes are there in bo & designer? : sap bobi
briefly describe the shell's responsibilities?
How do I boot from usb on windows 10 hp laptop?
Tell me why did you select accounting as your profession?
Write a program to retraive the data from all lists in sharepoint?
What is microsoft's web browser?
What is the difference between windows 7 and windows 8 and windows 10?
Give an example when you were experiencing peer pressure. How did you handle it?
Which file is used by controller to get mapping information for request routing?