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
- 2718 Views
- Fintellix, I also Faced
- E-Mail Answers
Post New Answer View All Answers
What is write ahead logging in sql server?
What is set serveroutput on?
how to create a new table in mysql? : Sql dba
Which is better join or inner query?
What are the triggers associated with image items?
What is sql query limit?
Why do we go for stored procedures?
What are the types pl/sql code blocks?
Is join an inner join?
How do you delete data from a table?
What is lookup table in sql?
Which command is used to delete a package?
How do I run sql?
Why do we need pl sql?
What are primary key and foreign key and how they work?
