select empid,sal,sal+lead(nvl(sal,0) from emp

write sql query following source are
EmpID, Salary
101 1000
102 2000
103 3000
I want the output format like following
empid,sal,composite_sal
101 1000 1000
102 2000 3000
103 3000 6000

Question Posted / niru

4 Answers
6939 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / niru

select empid,sal,sal+lead(nvl(sal,0) from emp_det

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the usage of analyze command in oracle?

1062

What are the original export and import utilities?

1104

What is the max number of columns in an oracle table?

957

What does sharding mean?

970

How do I spool to a csv formatted file using sqlplus?

992

Use of an integrity constraint is better to validate data. Explain

1007

How to test null values?

1063

How to assign values to data fields in record variables?

1000

What is raw datatype?

1097

How index is implemented in oracle database?

974

What is where clause in oracle?

1002

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2184

Can I create users through internet explorer in oracle 10g?

1043

How do we get field detail of a table?

1044

Explain overloading. Can functions be overloaded?

952