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
- 5633 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mukesh
select empid,
salary,
sum(salary) over(order by empid rows unbounded
preceding) composite_sal from source
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Respected sir, Please send me technical questions related to oracle apps..
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are the major difference between truncate and delete?
How to display row numbers with the records?
How do I start tns listener?
How to create tables for odbc connection testing?
What the is the diff between local index and global index. give some example.
How to run create database statement?
What are the general rules on data consistency?
What is a read only transaction in oracle?
What is memory advisor in Oracle?
State any two functions of oracle?
What's dateware house and what's clustor with practicle example
What is execute immediate in oracle?
What is a system tablespace?
