Ans: b. Null

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;

Question Posted / sudarshanbehera07@gmail.com

1 Answers
2686 Views
Fintellix, I also Faced
E-Mail Answers

Answer Posted / sudarshanbehera07@gmail.com

Ans: b. Null

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why partition by is used in sql?

1013

What is the difference between view and stored procedure?

949

What is rtm stands for?

1077

What is trigger in sql?

1066

What is before and after trigger?

932

What are the two characteristics of a primary key?

958

Is hadoop a nosql?

982

Is sql difficult?

1141

what are tables and fields? : Sql dba

1029

Can a trigger call a stored procedure?

1050

what is clause? : Sql dba

1051

what is the difference between join and union? : Sql dba

1089

What are the different types of joins in sql?

1732

What are the advantages of sql? Explain

1082

What do you understand by exception handling in pl/sql?

1011