select day,sale,sum(sale) over (order by day asc ) as 連續求和,sum(sale) over() as 總和 from t_temp;