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 are extents allocated to a segment?
What is a database schema in oracle?
Explain an extent?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to create tables for odbc connection testing?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How to synchronize 2 schema's objects?
How do I spool in oracle?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to convert a date to char in oracle? Give one example.
How do you store pictures in a database?
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....
Can you tell me how to add new column in existing views?how?How is possible?
How to retrieve data from an explicit cursor?