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
- 2711 Views
- Fintellix, I also Faced
- E-Mail Answers
Post New Answer View All Answers
What are sql functions? Describe in brief different types of sql functions?
Who is the owner of mysql database?
What is embedded sql with example?
explain the difference between delete , truncate and drop commands? : Sql dba
How do you modify a table in sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What sql does db2 use?
Is sql easier than java?
What is set serveroutput on?
What is trigger in sql? Explain
What are different types of keys?
What is not null in sql?
What does pragma mean?
Is like operator in sql case sensitive?
What is normalization in sql?
