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 32124. 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 2799Post New Fintellix Interview Questions
What does 200, 403 & 503 http error code mean?
Can WinMerge compare binary files?
what is one way , two way matching , three way , four way matching ?
What are Node.js Http module limitations?
Explain about strings in java?
What does dba stand for in technology?
Can we overload the main method in c#?
Is post back c#?
What is temp db database? : sql server architect
Which font is bigger times new roman or arial?
What is iron ferite?
What are plugins?
Can you do multiple if statements in excel?
What do I do if my windows 10 won't update?
What is Set-at-a-time or Set-oriented?