4. 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 Answers
- 1978 Views
- Fintellix, I also Faced
- E-Mail Answers
Post New Answer View All Answers
what is the stuff function and how does it differ from the replace function? : Sql dba
Is it possible for a table to have more than one foreign key?
Why is sharding used?
Is sql between inclusive?
what is self-join? : Sql dba
In what condition is it good to disable a trigger?
What is sql integrity?
How do I run pl sql in sql developer?
what is the difference between delete and truncate commands? : Sql dba
How do I view tables in sql developer?
Which type of cursor is used to execute the dml statement?
what is csv? : Sql dba
Can we create clustered index without primary key?
What operating systems are supported by oracle sql developer?
What is percent sign in sql?
