Interested to Buy Any Domain ? << Click Here >> for more details...
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 31344. 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 2714Post New Fintellix SQL PLSQL Interview Questions
- Fintellix Oracle AllOther Interview Questions (1) Fintellix SQL PLSQL Interview Questions (6)
Are you familiar with different rpa jobs?
How to cut or remove an element from the array?
How do you reset the Access ID/Password?
What is socket in node.js?
What is the purpose of a volatile variable?
Can you cancel chkdsk?
what is join logical file?
How many types of databases are there in ms access?
What is claims based authentication?
What do you mean by commit log in Cassandra?
Can digest cycle be forced to run manually?
What is difference between Pricing and Repricing?
What is stack example?
How do you count in python?
Where is table data stored in Apache Hive by default?
