>表包含名称和金额字段。金额可以是正数或负数。如果借记,则金额为正数,如果贷记,则为负数。用于删除总金额为 0 的名称的查询。
SELECT name , sum(amount) as total FROM table_name group by name having total =0;
删除查询的方式相同:
Delete FROM table_name group by name having sum(amount) =0;