新增文章

文章标题 分类 C# 云星空 K3 BOS K3 功能 用友 Oracle python SQL MySql PHP HTML script windows Access 影视后期 财务 服务 生活 内容 select a.FStockName,a.FMtrlNo,a.FMtrlName,a.FUnitStockName ,a.FIdentityId ,a.FQtyStock4 ,sum(b.FQtyStock4) FQtyStock4_Sum from TMP2983AE495E5511F0ACB40050563 a join TMP2983AE495E5511F0ACB40050563 b on ( b.FStockName = a.FStockName ) and ( b.FMtrlNo = a.FMtrlNo ) and ( b.FMtrlName = a.FMtrlName ) and ( b.FUnitStockName = a.FUnitStockName ) and ( b.FIdentityId <= a.FIdentityId ) group by a.FStockName,a.FMtrlNo,a.FMtrlName,a.FUnitStockName ,a.FIdentityId ,a.FQtyStock4 order by a.FStockName,a.FMtrlNo,a.FMtrlName,a.FUnitStockName ,a.FIdentityId ; SELECT a.group_column, a.date_column, a.value_column, SUM(b.value_column) AS group_running_total FROM your_table a JOIN your_table b ON b.group_column = a.group_column AND b.date_column < a.date_column GROUP BY a.group_column, a.date_column, a.value_column ORDER BY a.group_column, a.date_column; 返回 保存