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 74403. 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 24454. 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 1997Post New Fintellix Interview Questions
What are the steps you would take to transfer employee's salary from hr to fi?
What is a typical (day, week, month, or year) for a person in this job?
What does myeloid immunodeficiency cause?
Which servlet does the struts framework use?
Describe the mknod command and when you’d use it.
What will happen in case you have not issued the command: ‘set hive.enforce.bucketing=true;’ before bucketing a table in hive in apache hive 0.x or 1.x?
Define What is an ice dam sock?
What are the 5 types of research methods?
Explain what is the purpose of "extern" keyword in a function declaration?
What are the various ways of session supervision in servlets?
Why the orange trees are often sprayed with water?
Explain insurance project modules,and what we need to test on which functionality?
What is a finally block?
What are the 5 databases?
What is flask used for in python?