Grouping statistics-SQL interview questions

An SQL interview question is very simple. Year salary
----------------------
2000 1000
2001 2000
2002 3000
2003 4000 here is a company table. An SQL statement queries the salary of the following result year.
----------------------
2000 1000
2001 3000
2002 6000
2003 10000

 
-- Author: [DBA] Small seven set nocount ondeclare @ t table (Year int, salary INT) insert into @ t select, Union allselect, Union allselect select * From @ tselect. year, sum (B. salary) as salary from @ t a, @ t B where. year> = B. year group by. select Year of year, (select sum (salary) from @ t where year <=. year) salary from @ t a -- another statement provided by M, haha set nocount off year salary ----------- 2000 10002001 20002002 30002003 4000 salary in March ----------------- 2000 10002001 30002002 60002003 10000