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
- 4 Answers
- 5647 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
Can we create database in oracle using command line ?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How do you tell what your machine name is and what is its IP address?
How can we force the database to use the user specified rollback segment?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to view the tablespaces in the current database?
Please explain compound trigger in oracle?
How can I introduce multiple conditions in like operator?
What are the system predefined user roles?
How many types of auditing in Oracle?
Explain the use of indexes option in exp command.
What is the usage of save points in oracle database?
Where are the settings stored for each instance in oracle?
How to define an anonymous procedure without variables?
What are joins, explain all types of joins?
