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
7015 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 a synonym? What are its various types?

1095

What is background process in Oracle?

1084

Why does Oracle not permit the use of PCTUSED with indexes?

2408

What is literal?

987

Is it possible to insert comments into sql statements return in the data model editor ?

2536

What are the various constraints used in oracle?

1026

How to connect to oracle using service name instead of sid?

996

What is the oracle implicit cursor?

1036

defination of bitmap index

2096

Which is better Oracle or MS SQL? Why?

6345

How to export your connection information to a file?

1115

What is recovery manager in Oracle?

1036

How to do a full database export?

1085

What is SQL Tuning Advisor in Oracle?

1149

What is the difference between 10g OEM and 11g OEM?

950