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