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
时间: 2024-04-18 07:24:37 浏览: 16
在你的查询中添加了 GROUP BY 子句,这样可以按照指定的列进行分组聚合。以下是修改后的查询:
```sql
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 子句中的列。