1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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


4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case ..

Answer / sudarshanbehera07@gmail.com

Ans: b. Null

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is sql select statement?

0 Answers  

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,

What does trigger mean in psychology?

0 Answers  

How do I audit the sql sent to the server?

0 Answers  

What are sql commands?

0 Answers  




How do you update a sql procedure?

0 Answers  

Can %notfound return null after a fetch?

0 Answers  

What is on delete set null?

0 Answers  

what is an index? : Sql dba

0 Answers  

How do I clear the screen in sql plus?

0 Answers  

What are advantages of Stored Procedures?

3 Answers   Satyam,

What are different types of queries in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories