Koristi
CROSS JOIN:
Code:
select
a.id,
a.opis,
a.ulaz,
a.izlaz,
sum(b.ulaz-b.izlaz) as saldo
from
saldo a cross join saldo b
where
(b.id <= a.id)
group by a.id, a.ulaz
Izlaz izgleda otprilike ovako:
Code:
+------+------+------+-------+-------+
| id | opis | ulaz | izlaz | saldo |
+------+------+------+-------+-------+
| 1 | bla | 20 | 0 | 20 |
| 2 | bla | 0 | 10 | 10 |
| 3 | bla | 254 | 0 | 264 |
| 4 | bla | 12 | 0 | 276 |
| 5 | bla | 0 | 198 | 78 |
| 6 | bla | 24 | 0 | 102 |
+------+------+------+-------+-------+
Poz,
alex.
Alex: My favorite site is
http://localhost/
R.J. Oppenheimer: "I am become death, destroyer of worlds" (1945 AD)
tweet.13x ||
linkedin.13x