Need help for SQL - TechRepublic
Question
May 6, 2008 at 02:24 PM
nodysd

Need help for SQL

by nodysd . Updated 18 years, 1 month ago

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 discussion is locked

All Comments