1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

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 compare dates in oracle sql?

649

is there a tool to trace queries, like profiler for sql server?

593

What is the purpose of tables, private synonyms and public synonyms in Oracle?

585

Is primary key indexed by default in oracle?

540

What is a trigger oracle?

556




Explain view?

576

Explain alias?

703

How many types of cluster table in Oracle?

571

Does oracle database need java?

520

How can we find out the current date and time in oracle?

638

How to call a stored function with parameters?

561

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1556

What would you do with an in-doubt distributed transaction?

1466

Are truncate and delete commands same? If so why?

646

How to define a variable of a specific record type?

605