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 86133. 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 30974. 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 2659Post New Fintellix Interview Questions
In bootstrap, how can you create a pills navigation menu?
What is 'banking cash transaction tax (bctt)'?
How do I rename a column in postgresql?
How do I setup gmail on windows 10?
What is the min constitutes of haematite ore?
Explain functional concept of gsm and cdma?
What do you think about the latest algorithm update from google?
I am getting error "no communication channel" after changing the domain name? What is the solution?
What is archiving? How does it differ from deletion? : fi- general ledger master data
What is spring boot in java? : Spring Boot
What is the python idle?
Can I initialize unions?
we have a ods in process chain and the ods activation is taking long time how will u optimize the activation process.
What is the dictionary?
ow to bring suspect mode datbase online from scratch