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 86953. 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 31394. 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
How does linq to sql work?
What Kinds of Testing should be followed for an web application while Manual Testing . Ie., Regression , Integration , Alpha , Beta , Performance , Stress ,Load , Back End(database)...etc What is the serial way to follow the above Testing Kinds in manual testing of any application. Plz clear my doubt.
What is the difference between List View and Obj-List?
How to prepare serum from plasma?
What is oxygen os in oneplus 7?
Explain partitions?
Explain pure components in React js?
Write a program to print fibonacci series using recursion?
What are the different types of linked list?
input 1 input2 ouput1 output2 output 3 1 re 300 1 re 200 1 re 300 3 rc 500 1 re 200 2 rr 400 1 re 300 2 rr 400 1 rc 400 3 rc 500 1 rc 400 2 rr 700 2 rr 700 5 tt 900 5 tt 900 2 inputs r in flat file and output 1 is matched records,ouptput2 is unmatched of input1,output3 is unmatched of input2! how vl u get the output files using sequential order and to check with each and every records! let me know the procedure division ?
What is an agretope?
What should we do if we need last record to be active when a form is opened?
What is shadow dom?
What is dbcontext and dbset in entity framework?
What is the report to activate a feature?