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
- 1966 Views
- Fintellix, I also Faced
- E-Mail Answers
Post New Answer View All Answers
When you have to use a default "rollback to" savepoint of plvlog?
Is the primary key an index?
Does oracle use sql?
How to raise user-defined exception with custom sqlerrm ?
what is acid property in database? : Sql dba
How can I see all tables in sql?
Why do we create views in sql?
Where is all the data on the internet stored?
Which are the different case manipulation functions in sql?
how to delete an existing column in a table? : Sql dba
What is the difference between jpql and sql?
What is write ahead logging in sql server?
What are system versioned tables?
What does varchar include?
Can you have more than one trigger on a table?
