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.

4 total posts (Page 1 of 1)  
| 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

Back to Web Development Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums