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 linq to sql?

0 Answers  

What are dml commands?

0 Answers  

Define commit, rollback and savepoint?

0 Answers  

Why truncate is faster than delete?

0 Answers  

What is an Integrity Constraint?

4 Answers  




describe transaction-safe table types in mysql : sql dba

0 Answers  

How to pronounce postgresql?

0 Answers  

what are myisam tables? : Sql dba

0 Answers  

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

What is sql data?

0 Answers  

What is sql key?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories