1、表形式如下:
Year Salary
2000 1000
2001 2000
2002 3000
2003 4000
如何到如下形式的查询结果
Year Salary
2000 1000
2001 3000
2002 6000
查询语句:
select a.Year,sum(b.Salary ) as salary
from hello a,hello b
where b.Salary <= a.Salary
group by a.Year
1、表形式如下:
Year Salary
2000 1000
2001 2000
2002 3000
2003 4000
如何到如下形式的查询结果
Year Salary
2000 1000
2001 3000
2002 6000
查询语句:
select a.Year,sum(b.Salary ) as salary
from hello a,hello b
where b.Salary <= a.Salary
group by a.Year