汇总SQL
时间：2010-06-28 来源：hoo7
表形式如下：
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
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
相关阅读 更多 +
