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 SQL PLSQL Interview Questions
What is noise in modulation?
What is thread safe function?
How is transformation on rdd different from action?
How can i explain my project during interview?many time i expalain my project but they did't accept? please explain me.
How to rename a file using dos commands?
Which parts of lightning components are server-side and which are client-side ? : salesforce lightning component
What’s a “factor” inside the context of the internet of things (iot)?
Why do we need dependency injection?
Difference interview managed solution vs unmanaged solution.
How to get a list of all background sessions in the database?
What do you mean by custom tag in jsp?
Does ctrl r clear cache?
What is worker process?
How does the windows command interpreter (cmd.exe) parse scripts?
"What is the remedy if due exchanging, valve broke out during engine running operation?"