本文展示了一段SQL查询代码，用于统计指定日期范围内特定部门员工的现金销售额、挂账金额及合计总额。通过左连接将员工列表与销售记录表关联，并使用CASE语句对不同类型交易进行分类求和。
SELECT MAX(employeelist.姓名) AS 姓名,
sum(case out.typeid when 7 then 金额 else 0 end) as 现金,
sum(case out.typeid when 8 then 金额 else 0 end) as 挂帐,
sum(out.金额) AS 合计
FROM out LEFT OUTER JOIN
employeelist ON out.employeeid = employeelist.id
WHERE (out.日期 >= '2008-07-01') AND (out.删除 = 0) AND (out.deparid = 7)
GROUP BY out.employeeid
sum(case out.typeid when 7 then 金额 else 0 end) as 现金,
sum(case out.typeid when 8 then 金额 else 0 end) as 挂帐,
sum(out.金额) AS 合计
FROM out LEFT OUTER JOIN
employeelist ON out.employeeid = employeelist.id
WHERE (out.日期 >= '2008-07-01') AND (out.删除 = 0) AND (out.deparid = 7)
GROUP BY out.employeeid
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
