Web Development

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

Question

Locked

Need help for SQL

By nodysd ·
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

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

This link might help you..

http://www.1keydata.com/sql/sqlorderby.html

Please post back if you have any more problems or questions.

Collapse -

refer pl/sql

by sapna.goel In reply to Need help for SQL

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

Collapse -

refer pl/sql

by sapna.goel In reply to Need help for SQL

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

Related Discussions

Related Forums