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 86983. 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 31414. 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 2720Post New Fintellix Interview Questions
fuel-air ratio in a petrol engine fitted with suction carburettor,operating with dirty air filter as compared to clean filter will be
What is a declaration?
What is Secondary IgA?
What browsers use activex?
Explain dd statement in jcl?
what do you think are your strengths and weaknesses?
What is 'mysqlimport'?
what is diffrence b/w file-aid tool and file-aid utility???
What is the port 8000?
How are dependent the app.config and the machine.config files?
What is lineage graph in Apache Spark?
How do I find environment variables?
Which method do you follow to get a record from a million records? (Searching not from database, from an array in php)?
Explain the functions of the following annotations: @component, @controller, @repository, @service.
Is python a shell?