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 87913. 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 32084. 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 2797Post New Fintellix Interview Questions
What salary range are you looking for at Schlumberger?
Explain table?
What is spring controller?
Can you change default font in powerpoint?
What is difference between session storage and local storage?
What are the different life-cycle methods?
What are Custom Activities?
What is pdo :: fetch_assoc?
I WANT BHEL PREVIOUS QUESTION
what is circuit recombiner and how it is different from circuit breaker
What are the Data providers in ADO.Net?
What is unique key constraint?
What is clr? Difference between clr & cts?
Explain the difference between array and list in scala?
What is a spanning tree?does the minimum spanning tree of a graph give the shortest distance between any 2 specified nodes?