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
7103 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

How to create a new user account in oracle?

1023

How to use "while" statements in oracle?

1331

What is bind variable in oracle 11g?

1041

What is primefaces used for?

1053

How to revoke create session privilege from a user in oracle?

1021

How to apply filtering criteria at group level in oracle?

1045

What is a select query statement in oracle?

972

How to use windows user to connect to the server?

991

How to create a table interactively?

1097

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2073

What is an external table?

1028

How do I spool in oracle?

1015

What are the arithmetic operations?

1087

What are the restrictions in a oracle read only transaction?

1040

various types of hints and their usage

2701