Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2800 Views
- Fintellix, I also Faced
- E-Mail Answers
Post New Answer View All Answers
What is the advantage of index in sql?
How does cross join work in sql?
Why use stored procedures?
How is data stored on a disk?
What is time based sql injection?
What is using in sql?
Why indexing is needed?
Can we group by two columns in sql?
How does pl sql work?
How global cursor can be declare with dynamic trigger ?
Cite the differences between execution of triggers and stored procedures?
How can you view the errors encountered in a trigger?
what is data control language? : Sql dba
What is the starting oracle error number?
Why do we use sqlite?
