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 86933. 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 31374. 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 2718Post New Fintellix Interview Questions
Which types of network application you can build using node.js?
How do you transfer data from sap erp system to scm system?
What is magento marketplace?
What is syscat in db2?
How do I delete a table in mysql workbench?
On an electric schematic, what does the symbol of a horizontal line interrupted by a saw tooth shaped line represent?
What is the process to create a table in the data dictionary?
What are the advantages of a procedure?
How do you copy conditional formatting in excel?
What is the root account?
How is consistency maintained by Stateful Session through transaction updates ?
What is difference between javascript and jscript?
Name some autoimmune diseases.
How to select first n records in teradata?
What do you know about mongodb?