running sum in SQL

I have a sorted table and I want to create another one that would contain a field that is a running sum. I cannot figure it out in SQL, I know it’s possible in Excel, Access …

day total for day running sum
1 150 150
2 50 200
3 -120 80

…etc

Thanks,