SELECT 行号,
MAX(CASE WHEN 元素ID='001' THEN 字符数据列 ELSE '' END) AS 姓名,
MAX(CASE WHEN 元素ID='002' THEN 字符数据列 ELSE '' END) AS 部门,
SUM(CASE WHEN 元素ID='003' THEN 金额数据列 ELSE 0 END) AS 基本工资,
SUM(CASE WHEN 元素ID='004' THEN 金额数据列 ELSE 0 END) AS 奖金合计,
SUM(CASE WHEN 元素ID='005' THEN 金额数据列 ELSE 0 END) AS 全勤奖,
SUM(CASE WHEN 元素ID='006' THEN 金额数据列 ELSE 0 END) AS 安全奖,
SUM(CASE WHEN 元素ID='007' THEN 金额数据列 ELSE 0 END) AS 车补,
SUM(CASE WHEN 元素ID='008' THEN 金额数据列 ELSE 0 END) AS 工资总计,
SUM(CASE WHEN 元素ID='009' THEN 金额数据列 ELSE 0 END) AS 应扣金额,
SUM(CASE WHEN 元素ID='010' THEN 金额数据列 ELSE 0 END) AS 实发合计
FROM 数据存储表
GROUP BY 行号