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 73663. 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 24144. 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 1949Post New Fintellix Interview Questions
How do I download joomla templates?
How can you validate emails using a single query?
State some of lmo importance.
Explain the properties of union. What is the size of a union variable
How the dose for children is being estimated based on preclinical data?
Differentiate between validated and Compiled in the Datastage?
Why is the team uniquely capable to execute the company's business plan? - Venture Capitalists
What is the minimum and maximum font size in word?
which methos do you invoke on the dataadapter control to load your generated dataset with data?
Explain the difference between HTTP and HTTPS in database?
Can an airplane fly without a tail?
What is year dependent fiscal year variant?
How splunk helps the enterprise?
How to connect the .accdb database file of microsoft access to the Visual Basic 6.0 forms?
Tell me with the kind of work experience you have had, do you think this job would bore you? : insurance sales