mysql - 如何取回余额

Question

[![派对余额图片 1][1]][1]

[![派对余额图 2][2]][2]

谢谢问题已解决

标签： mysqlsql

Answer 1

您可以使用条件聚合：

SELECT customer, (sum(debit) - sum(credit)) as balance, 
       MAX(CASE WHEN credit > 0 THEN date END) as last_credit_date
FROM ledger l
GROUP BY customer;