1
Programming / SQL running total
« on: May 19, 2023, 05:54:52 pm »
Hi,
This statement works with SQLite;
select amount, (select sum(t2.amount) from example t2 where t2.id <= t1.id) as accumulated from example t1 order by id
Does anyone know how to make it work with dBase (IV/V)?
(I've found many examples for other databases but none of them works with dBase.)
This statement works with SQLite;
select amount, (select sum(t2.amount) from example t2 where t2.id <= t1.id) as accumulated from example t1 order by id
Does anyone know how to make it work with dBase (IV/V)?
(I've found many examples for other databases but none of them works with dBase.)