SUM(i.进货量) AS "进货总量"

在SQL中，可以使用SUM函数来计算某个字段的总和。例如，如果你想计算"进货量"字段的总和，可以使用以下语句：

SELECT SUM(i.进货量) AS "进货总量" FROM 表名 i;

其中，"表名"是你要查询的表的名称，"进货量"是你要计算总和的字段名称。执行以上语句后，将会返回一个名为"进货总量"的列，其中包含了"进货量"字段的总和值[^1]。

相关问题

select C.GZ_YM AS 缴费年月, C.C21163 AS 养老保险单位缴纳, C.C2144 AS 养老保险个人缴纳, SUM(C.C21163+C.C2144) AS 养老合计, C.C21165 AS 失业保险单位缴纳, C.C2153 AS 失业保险个人缴纳, SUM(C.C21165+ C.C2153) AS 失业合计, C.C21166 AS 工伤保险单位缴纳, C. C21164 AS 医疗保险单位缴纳, C.C2147 AS 医疗保险个人缴纳, SUM( C.C21164+C.C2147) AS 医疗合计, SUM(C.C21163+C.C21165+ C. C21164+ C.C21166) AS 单位缴纳总合计, SUM(C.C2144+C.C2153+C.C2147) AS 个人缴纳总合计, SUM(C.C21163+C.C21165+ C. C21164+ C.C21166+C.C2144+C.C2153+C.C2147) AS 总合计 FROM C21 C LEFT JOIN b01 on c21.dept_id - b01.dept_id 加GROUP BY

C.GZ_YM AS 缴费年月,
C.C21163 AS 养老保险单位缴纳,
C.C2144 AS 养老保险个人缴纳,
SUM(C.C21163+C.C2144) AS 养老合计,
C.C21165 AS 失业保险单位缴纳,
C.C2153 AS 失业保险个人缴纳,
SUM(C.C21165+ C.C2153) AS 失业合计,
C.C21166 AS 工伤保险单位缴纳,
C. C21164 AS 医疗保险单位缴纳,
C.C2147 AS 医疗保险个人缴纳,
SUM( C.C21164+C.C2147) AS 医疗合计,
SUM(C.C21163+C.C21165+ C. C21164+ C.C21166) AS 单位缴纳总合计,
SUM(C.C2144+C.C2153+C.C2147) AS 个人缴纳总合计,
SUM(C.C21163+C.C21165+ C. C21164+ C.C21166+C.C2144+C.C2153+C.C2147) AS 总合计

FROM C21 C
LEFT JOIN b01 on c21.dept_id - b01.dept_id

GROUP BY C.GZ_YM

SELECT A.A0101 AS 姓名, A.A0190 AS 人员编号,A.A0177 AS 身份证号,A.A0191 AS 在职或离职,A.A1017 AS 离职时间,C.GZ_YM AS 缴费年月, --,缴费状态, A.BXJS AS 缴费基数, C.C21163 AS 养老保险单位缴纳,C.C2144 AS 养老保险个人缴纳, SUM(C.C21163+C.C2144) AS 养老合计, C.C21165 AS 失业保险单位缴纳, C.C2153 AS 失业保险个人缴纳, SUM(C.C21165+ C.C2153) AS 失业合计, C. C21164 AS 医疗保险单位缴纳,C.C2147 AS 医疗保险个人缴纳, SUM( C.C21164+C.C2147) AS 医疗合计, C.C21166 AS 工伤保险单位缴纳 SUM(C.C21163+C.C21165+ C. C21164+ C.C21166) AS 单位缴纳总合计, SUM(C.C2144+C.C2153+C.C2147) AS 个人缴纳总合计, SUM(C.C21163+C.C21165+ C. C21164+ C.C21166+C.C2144+C.C2153+C.C2147) AS 总合计; from C21 C LEFT JOIN view_a01 A ON C.A0188=A.A0188 加GROPBY

在你的查询中添加了 GROUP BY 子句，这样可以按照指定的列进行分组聚合。以下是修改后的查询：

SELECT 
    A.A0101 AS 姓名, 
    A.A0190 AS 人员编号,
    A.A0177 AS 身份证号,
    A.A0191 AS 在职或离职,
    A.A1017 AS 离职时间,
    C.GZ_YM AS 缴费年月,
    --,缴费状态,
    A.BXJS AS 缴费基数,
    C.C21163 AS 养老保险单位缴纳,
    C.C2144 AS 养老保险个人缴纳,
    SUM(C.C21163 + C.C2144) AS 养老合计,
    C.C21165 AS 失业保险单位缴纳,
    C.C2153 AS 失业保险个人缴纳,
    SUM(C.C21165 + C.C2153) AS 失业合计,
    C.C21164 AS 医疗保险单位缴纳,
    C.C2147 AS 医疗保险个人缴纳,
    SUM(C.C21164 + C.C2147) AS 医疗合计,
    C.C21166 AS 工伤保险单位缴纳,
    SUM(C.C21163 + C.C21165 + C.C21164 + C.C21166) AS 单位缴纳总合计,
    SUM(C.C2144 + C.C2153 + C.C2147) AS 个人缴纳总合计,
    SUM(C.C21163 + C.C21165 + C.C21164 + C.C21166 + C.C2144 + C.C2153 + C.C2147) AS 总合计
FROM 
    C21 C 
    LEFT JOIN view_a01 A ON C.A0188 = A.A0188
GROUP BY 
    A.A0101, 
    A.A0190,
    A.A0177,
    A.A0191,
    A.A1017,
    C.GZ_YM,
    A.BXJS,
    C.C21163,
    C.C2144,
    C.C21165,
    C.C2153,
    C.C21164,
    C.C2147,
    C.C21166;

在这个修改后的查询中，我们使用 GROUP BY 子句对指定的列进行分组，以便在聚合函数中计算每个分组的总和。你可以根据实际需求调整和适应 GROUP BY 子句中的列。