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

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1983

What is ordinary table in oracle?

1238

In oracle there is column command, how will you explain that?

1135

How to use values from other tables in update statements using oracle?

1123

What is the data pump import utility?

1074

What is a dead lock in oracle?

1175

How to execute a stored procedure in oracle?

1146

Explain the use of rows option in imp command.

1133

Explain oracle insert into command?

1157

What is materialized view in Oracle?

1114

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1063

How to create a new table in oracle?

1231

What privilege is needed for a user to create tables in oracle?

990

What is translate in oracle?

1140

What is a table index in oracle?

1185