表形式如下：
Year Salary
2000 1000
2001 2000
2002 3000
2003 4000
想得到如下形式的查询结果
Year Salary
2000 1000
2001 3000
2002 6000
2003 10000
sql语句怎么写?
SELECT b.YEAR, SUM (a.salary) salary
FROM t_salary a, t_salary b
WHERE a.YEAR <= b.YEAR
GROUP BY b.YEAR
阅读(498) | 评论(1) | 转发(0) |
