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
- 2625 Views
- Fintellix, I also Faced
- E-Mail Answers
Post New Answer View All Answers
What is pls integer?
When is the explicit cursor used ?
What is row_number () in sql?
How to select 10 records from a table?
Is vs as in pl sql?
What are the types pl/sql code blocks?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
what is sql? : Sql dba
What is snowflake sql?
What is cross join example?
What operating systems are supported by oracle sql developer?
tell me about various levels of constraint. : Sql dba
What is sql injection owasp?
What is cte?
What is difference between joins and union?
