Skip to content

Instantly share code, notes, and snippets.

@ebta

ebta/mysql_balance.sql

Last active June 25, 2022 09:43
Show Gist options
  • Save ebta/22584b01710a3d379f6fe3f3c5cc8f11 to your computer and use it in GitHub Desktop.
Save ebta/22584b01710a3d379f6fe3f3c5cc8f11 to your computer and use it in GitHub Desktop.
Download ZIP
Query menghitung balance (saldo) di MySQL
Raw
mysql_balance.sql
SET @saldo = 3000000;
SELECT id_sample, uraian, debet, kredit, (@saldo := @saldo + (debet - kredit)) as Saldo
FROM sample;
-- Alternatif as one query statements
SELECT s.id_sample, s.uraian, s.debet, s.kredit, (@saldo := @saldo + (s.debet - s.kredit)) as Saldo
FROM (SELECT @saldo := 3000000) AS dummy
CROSS JOIN sample s;
@trisnawan
Copy link

bang, bagaimana kalo datanya sudah banyak, dan cara agar query nya tidak lambat?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment