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 86913. 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 31364. 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 2718Post New Fintellix Interview Questions
Why using 10% DMSO for shocking my Cos-7 Cells - after DEAE-Dextran Transfection ?
exit () is used to a) exit () terminates the execution of the program itself b) exit () terminates the execution of the loop c) exit () terminates the execution of the block d) none of the above
One starts counting from 0 to max and the other stars from max to 0. Which one executes fast.
What does pin to start mean in windows 10?
What is looper, handler, and message queue in Android?
Whether we need to add jQuery file in both Master and Content page?
Which sorting algorithm has minimum number of swaps?
What is the default database provided by Apache Hive for metastore?
You are required to restore the file memo.ben. It was backed up in the tar file MyBackup.tar. Which command would you use to do it?
How does SEBI affect the economy of the country?
What are the different types of sales agents that are present in this field?
Explain me a situation in which you've been required to use your communication skills in order to get the job done? : insurance health
How efficient is binary search?
How do I increase font size in excel drop down list?
Explain how servlet life cycles?