Question Locked

Need help for SQL

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a table column name,salary,phone. I want to show all recods with counter variable add salary column.Like
if Table has values

Name Salary Phone
-----------------------------------
abc 12,000 905-624-1234
xyz 10,000 416-123-4567
opg 08,000 647-568-7890
.
.

Now I need query to view all records like

Name Salary Accumulate Salary
------------------------------------------
abc 12,000 12,000
xyz 10,000 22,000
opg 08,000 30,000
.
.

Please help to solve this issue

Thnkx

4 replies

by sapna.goel

you have to calculate the accumulate salary by applying the functions.To know the functio, plz refer pl/sql

by sapna.goel

you have to calculate the accumulate salary by applying the functions.To know the function, plz refer pl/sql

This discussion is closed to new replies.