http://sql根据不同的类型和年份 累加值 http://sql根据不同的类型和年份 累加值点击打开链接 点击打开链接 点击打开链接 select a.*, (select sum( price) from Interview as b where b. City=a. City and b. Year <=a. Year ) as sumPrice FROM Interview as a