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 73973. 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 24304. 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 1968Post New Fintellix SQL PLSQL Interview Questions
What is sqldatareader c#?
What is excel default font?
What is the need of multimedia course?
Explain the benefits of quick test pro(qtp)?
Are there any security issues with ajax?
Why to use node.js?
Define a process flow diagram?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What should be done to override the governor limit that restricts you from fetching more than 50,000 records in a soql query ?
Explain what is regions and endpoints in aws?
What is cookie?
What are the major uses of hexachlorophene, chlorhexidine, and triclosan as agents for controlling microorganisms?
What is huffman’s algorithm?
What are the different turn on methods of scr?
What is change data capture (cdc) feature?