--是这样吗?SELECT 客户, SUM(借方) AS 汇入金额, SUM(贷方) AS 提货金额, SUM(余额) AS 余额
FROM [客户账务数据]
GROUP BY 客户
HAVING SUM(余额)<0--结果
/*
客户 汇入金额 提货金额 余额
ko 4000 8000 -4000
*/
FROM [客户账务数据]
GROUP BY 客户
HAVING SUM(余额)<0--结果
/*
客户 汇入金额 提货金额 余额
ko 4000 8000 -4000
*/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货