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 87043. 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 31464. 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 2725Post New Fintellix Interview Questions
What should we do if we want to know which users are reaching our site?
What is hadoop, hbase, hive and cassandra? Specify similarities and differences among them.
Why is ubuntu called ubuntu?
What is the difference between truncate and delete in mysql?
What is connection pooling and how do you make your application use it?
What are the ways in which spiders can find the web site? - SEO
Mention what are the connectors used in tomcat?
Define database layer?
What is dynamic range?
What is the most powerful processor?
When to use {{}} ? How to interpolate variables or dynamic variable names?
if appointed at aryabhatt school for how long should we expect you work with us
What are the general trends in trade?
Explain radiology?
Is iis secure?