SQL calculates the salary and

You already know the original table
Year salary
---------------------------------------
2000 1000
2001 2000
2002 3000
2003 4000
Display query results
Year salary
---------------------------------------
2000 1000
2001 3000
2002 6000
2003 10000

That is, salary is the sum of the previous year's salary;

Two answers are provided here.
First:
Select B. Year, sum (A. Salary)
From salary A, salary B
Where a. year <= B. year group by B. Year
Order by B. Year;

Salary is the payroll.

Second:
Select s1.year "year", (select sum (s2.salary) from salary S2 where s2.year <= s1.year) "salary" from salary S1;