date是数据类型不能作为字段名称。我改为dateNumberselect dateNumber, sum(sum(DailyOut)) over(order by dateNumber rows between unbounded preceding and current row) current_total_sales from PRO group by dateNumber;
呵呵少个 日产 给你加上 select dateNumber, sum(DailyOut), sum(sum(DailyOut)) over(order by dateNumber rows between unbounded preceding and current row) current_total_sales from PRO group by dateNumber;
select i_date,v_dailyout ,sum(v_dailyout)over(order by I_Date ) from t_pro;
select t1.datenumber, sum(t1.dailyout) , sum(sum(t1.dailyout)) over (order by t1.datenumber) from Table1 t1 group by t1.datenumber
select dateNumber,
sum(DailyOut),
sum(sum(DailyOut)) over(order by dateNumber rows between unbounded preceding and current row) current_total_sales
from PRO
group by dateNumber;
select t1.datenumber, sum(t1.dailyout) , sum(sum(t1.dailyout)) over (order by t1.datenumber) from Table1 t1
group by t1.datenumber
这样就可以了,
连续加和的思路