本文介绍了一个复杂的SQL查询案例，该查询用于从多个表中选择数据并进行聚合计算，包括收入和支出的总和，并按部门ID过滤运行记录。
select runningid,runningname,payin=(case paytype when 'in' then paytotal else 0 end),payout=(case paytype when 'out' then paytotal else 0 end) from
(
select paytype,sum(pay) as paytotal,runningid,runningname from
(
select paytype,pay,runningid,runningname from
(
select paytype='in',pay,runningid,runningname from f_payi where runningid in (select id from f_running where deptid=@deptid)
union
select paytype='out',pay,runningid,runningname from f_payo where runningid in (select id from f_running where deptid=@deptid)
) a
) b group by paytype,runningid,runningname
) c
使用case指定查询结果的字段
最新推荐文章于 2024-07-01 21:25:44 发布
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
