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 85703. 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 30764. 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 2629Post New Fintellix Interview Questions
Define fbus protocol?
Do you know the features of sas?
What is the latest android version 2019?
What are runtime exceptions?
What is sitemesh?
What is the difference between wifi and mifi?
How to pass a variable by value in wordpress?
How to define a vsam file in cics getting into cics to define a vsam file.
I went to Germany for my masters and stayed there for 1.5 months. Due to personal reasons I came back to india and I want to apply for student visa for USA..will there be any issues?
How do you put a background on powerpoint?
What is pass through metrics in microstrategy?
What are the websphere packages?
Does web api called using javascript would work from outlook in offline mode?
What is isotope switching?
what has the greater market share of Linux SW/HW?