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 SQL PLSQL Interview Questions
why three pick-up tubes are provided in a clour camera?
When we do cardonitriding or casehardening operation for a plain carbon steel the case depth, hardness & microstructure are not alike why and what are the basicthing, which makes such a difference.
can you tell me what are the dimension tables are used in project
How can I improve my c++ skills?
Can anyone please answer the below question on Manual Testing: Tell me about atleast 5 bugs you come across in your last testing?
when the time of backcharging the transformer three phases only enough or three phase with neutral is must.from these which one is the best one.
When we use proxy and when we use for idoc?
What is an Unsolicited Application Group? How Can You Define Unsolicited Application Group?
Can you write down a general regular expression for extracting ip address from logs?
How can I restore windows explorer?
What is the lead process?
Name the property which is on a combo box do you set with a column name, prior to setting the data source, to display data in the combo box?
How is account type connected to document type?
What is a docstring?
Tell me what is the maximum number of satellite hops allowed in voice communication?