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 are the usages of sql?

0 Answers  

Is primary key always clustered index?

0 Answers  

How do I restart sql?

0 Answers  

What is a record in a database?

0 Answers  

Is pl sql better than sql?

0 Answers  




write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

How do I start sql from command line?

0 Answers  

what is the functionality of the function htmlentities? : Sql dba

0 Answers  

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 Answers  

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

Explain mutating table error.

0 Answers  

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

For more SQL PLSQL Interview Questions Click Here
Categories