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
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
How to create a new user account in oracle?
How to use "while" statements in oracle?
What is bind variable in oracle 11g?
What is primefaces used for?
How to revoke create session privilege from a user in oracle?
How to apply filtering criteria at group level in oracle?
What is a select query statement in oracle?
How to use windows user to connect to the server?
How to create a table interactively?
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....
What is an external table?
How do I spool in oracle?
What are the arithmetic operations?
What are the restrictions in a oracle read only transaction?
various types of hints and their usage