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 85673. 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 30764. 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 2628Post New Fintellix Interview Questions
How can we create a data-driven framework using testng?
Topic- looping,function overloading,nesting ,polymorphism. Aim - to write a function with a name buzz-buds,that will check whether the given numbers are buddies or not on the basis of no. of parameters passed during function calling.
When Namenode is down what happens to job tracker?
How arrays are stored in memory in java?
Tell me which protocol can be applied when you want to transfer files between different platforms, such between unix systems and windows servers?
What are the encryption functions in php?
Explain the difference between java and scala?
What is a footnote example?
Is google a server?
Which event occurs when a user drags an item in a treeview or listview control?
Why subroutine used in programs?
Differentiate between a constructor and a method in C++.
Give us a brief about the types of data models available ui5?
What are the designer tools for creating transformations?
How do you go to a directory in unix?